Sites anglophones


SQL Server Diagnostic Information Queries Detailed, Day 3

Publié le 3 janvier 2016 sur sqlskills.com - glen berry
 

For Day Three of this series, we are up to Query #5, which is Global Trace Flags. This query simply runs a DBCC command to determine what global trace flags are currently in effect for your current instance of SQL Server. Query #5 is shown in Figure 1. …

Interview Question of the Week #052 – Print String in Reverse Order

Publié le 3 janvier 2016 sur journey to sqlauthority
 

Last week, I attended the last interview of the year. One of my co-interviewer asked a coding question to the candidate. In this type of question, the candidate is given one hour with SQL Server with a help file. The computer does not have internet can …

Interview Question of the Week #052 – Print String in Reverse Order Without Using Reverse Function

Publié le 3 janvier 2016 sur journey to sqlauthority
 

Last week, I attended the last interview of the year. One of my co-interviewer asked a coding question to the candidate. In this type of question, the candidate is given one hour with SQL Server with a help file. The computer does not have internet can …

How to Solve SQL Server Challenges

Publié le 2 janvier 2016 sur sqlmag.com
 

Sponsored by: Tegile Thursday, February 11th, 2016 @ 2pm ET read more

Webcast: How to Solve SQL Server Challenges

Publié le 2 janvier 2016 sur sqlmag.com
 

Sponsored by: Tegile Thursday, February 11th, 2016 @ 2pm ET read more

SQL Server Diagnostic Information Queries Detailed, Day 2

Publié le 2 janvier 2016 sur sqlskills.com - glen berry
 

Query #3 is Server Properties. This query simply makes multiple calls to the T-SQL SERVERPROPERTY metadata function to retrieve quite a bit of useful information about the current instance of SQL Server that you are connected to. Query #3 is shown in F …

SQL SERVER – Script: Finding Cumulative IO Per Database File

Publié le 2 janvier 2016 sur journey to sqlauthority
 

Sharing SQL Server related scripts is something I tend to do from time to time. At the SQLPass one of the attendees for my session around 42 tips asked, if I have any script that is handy to find the IO utilization per database file because they had co …

SQL Server Diagnostic Information Queries Detailed, Day 1

Publié le 1 janvier 2016 sur sqlskills.com - glen berry
 

Since I have not learned my lesson from doing a daily blog post for a month from the previous several times that I have done it in the past, I am going to start a new blog series for the month of January 2016. This one will discuss each the queries in …

Icons and the real world

Publié le 1 janvier 2016 sur sqlblog.com
 

Just realised that book icons are another one that will probably lose meaning over time. That’ll apply to book icons for dictionaries and thesauruses too.   Phone icons are already pretty odd as many kids would never have seen a phone that looks l …

Stairway to T-SQL: Beyond The Basics Level 2: Writing Subqueries

Publié le 1 janvier 2016 sur sqlservercentral.com
 

In this level of the Beyond the T-SQL Basics stairway, we will be discussing the different aspects of a subquery.

SQL SERVER – FIX: SQLServerAgent is not currently running so it cannot be notified of this action. (Microsoft SQL Server, Error: 22022)

Publié le 1 janvier 2016 sur journey to sqlauthority
 

Getting error and finding the cause is something which I like. And off late over the blogs I have shared a number of such incidents that have helped me figure out stuffs all by myself. Of course, I do my research and more often than not make things com …

2015 review: the year by the numbers

Publié le 31 décembre 2015 sur sqlskills.com - paul randall
 

The last post of the year! It’s been a really excellent year all round and time for my traditional post counting down some of the numbers that have been my life this year. 109318: the number of miles I flew on United 33313: my current tweet total …

[Video] Office Hours 2015/12/30

Publié le 31 décembre 2015 sur brentozar.com
 

Every Wednesday, we run a free Office Hours session where you can wander in, ask SQL Server questions, and get answers of dubious quality. In this week’s Office Hours, Angie and Brent talk about how to configure TempDB, when to use SAN …

Plan for failure in automated deployments

Publié le 31 décembre 2015 sur sqlservercentral.com
 

Failures happen with manual and automated releases, they are a fact of life. Make sure you know how and when to rollback failed deployments

Actual “Number of Rows Read” in SQL Server Execution Plans

Publié le 31 décembre 2015 sur sqlservercentral.com
 

Kendra Little takes a look at the upcoming SQL Server 2016 ‘Number of Rows Read’ feature in action.


Pages :