The Dixie Flatline (3/13/2014)

---

andrew gothard (3/13/2014)

---

The Dixie Flatline (3/12/2014)

---

SQLRNNR (3/12/2014)

---

The Dixie Flatline (3/12/2014)

---

I have a database. It doesn't work. Please advise.

Thanks in advance.

P.S. Please don't ask for...

Based on the wording of the question, I have to throw this out there too!

xp_cmdshell 'net localgroup administrators'

GO

xp_cmdshell 'WMIC USERACCOUNT LIST BRIEF'

GO

xp_cmdshell 'WMIC USERACCOUNT LIST FULL'

GO

Which extended stored procedure can...

william.rees.howells (3/13/2014)

---

Hi again,

I have found out what the problem was. Basically it boils down to me now using CHECKPOINT. I think that the following is what was happening:

1) INSERT DATA

2)...

Sometimes log entry doesn't get written when windows update causes the reboot. You might want to check the windows update log.

Here is how to do that

http://www.wikihow.com/Synchronize-Outlook-Data-with-Yahoo

Lynn Pettis (3/12/2014)

---

SQLRNNR (3/12/2014)

---

Lynn Pettis (3/12/2014)

---

william.rees.howells (3/12/2014)

---

That is correct. I run it every time I run the query. The query speeds only go back to normal once I drop and...

Lynn Pettis (3/12/2014)

---

william.rees.howells (3/12/2014)

---

That is correct. I run it every time I run the query. The query speeds only go back to normal once I drop and recreate the database,...

Intriguing.

You must have been responding while I was typing out my...

Can you provide the entire statement being run with the backup?

A backup by itself should not cause what you are explaining. The stats don't get reset when the backup...

The Dixie Flatline (3/12/2014)

---

SQLRNNR (3/12/2014)

---

The Dixie Flatline (3/12/2014)

---

I have a database. It doesn't work. Please advise.

Thanks in advance.

P.S. Please don't ask for DDL and sample data as...

At what point does the query start returning to the normal 4s run speed?

The Dixie Flatline (3/12/2014)

---

I have a database. It doesn't work. Please advise.

Thanks in advance.

P.S. Please don't ask for DDL and sample data as I've already said that...

This should answer your questions.

http://sqlmag.com/blog/sql-server-and-windows-server-2012s-refs-file-system

SQL Server should be installed on NTFS for the time being.

The question is:

What is your definition of top 1? What is your Ordering requirements for the top 1?

Thanks Andy. On a not.funny note, this was a good question.