That's caused by a long running checkpoint operation, where the data gets written to disk from memory. It's not an indication of a memory leak. It's an indication of large,...

Tuning is a cyclical process that you just keep doing and doing. Basically you monitor a server, gather metrics on what's performing well, what isn't, what normal looks like, and...

I don't know that I'd use ODBC. I'd rather go for as direct a connection as possible. You should be able to make a direct connection if it's Microsoft Azure...

I have to say, this really sounds like interview questions. I'm only answering interview questions if I get the job.

Perry Whittle (6/30/2014)

---

It's not the server dictating this. You can have 100 databases all with the primary...

Not sure then in that case. I've seen poor performance in some machines after waking, but not a specific query issue with SQL Server.

george sibbald (6/30/2014)

---

if your system has been running stable for a few years with no issues, you are unlikely to hit new problems, and known issues and security fixes will...

Chowdary's (6/30/2014)

---

Hi Mr.Garnt Thank you for the Reply.

Actually am checking the server which is having only 2012.There am getting the issue.

Pls help me out if there is any...

Is the machine you're querying from and the data location and the machine going to sleep, all the same machine? If so, I suspect you're probably seeing some memory artifact...

Chowdary's (6/30/2014)

---

Dear Whittle Thank you very much for giving the Reply.

If i change the Names of Mdf and Ldf from the Files page i can able to restore the Database...

This is flat out a problem:

RTRIM(REPLACE(REPLACE(REPLACE(REPLACE(a.CONTACT_PHONE

If you're interested in query tuning, you might want to hold off purchasing a little while. I should have my 2014 update of the query tuning book done within a...

You really want to look at the execution plan on something like this. There is no obvious issue with your T-SQL, so you read the execution plan to understand how...

system_health extended event session is already capturing deadlock information for you if you haven't disabled it.

Personally, I don't like being out of support because if you have some type of major issue, Microsoft may not help. Most of the time and in most circumstances, this...