The '-------' below the column names is the seperator between the header and the data. You will have the same if you show your query results in text mode. If...

Hi...

Stuart Davies (11/20/2014)

---

Koen Verbeeck (11/20/2014)

---

I have been nominated for the "Author of the Year" award at MSSQLTips.com.

This means people have to vote for me (or other people, but preferable me):

http://www.mssqltips.com/MSSQLTipsAuthorVoting.asp

Note...

Koen Verbeeck (11/20/2014)

---

I have been nominated for the "Author of the Year" award at MSSQLTips.com.

This means people have to vote for me (or other people, but preferable me):

http://www.mssqltips.com/MSSQLTipsAuthorVoting.asp

Note that you...

Without the queryplan there is not much we can do. Is the query itself well written? Is the query using the existing indexes in a efficient way (like: seek instead...

AFAIK some third party monitor applications are able to do what you need, although I don't have any experience with them.

If you want to build your own solution you should...

Has the amount of data increased over time? More data generally means more time to execute. If possible try archiving old data that is not needed anymore. Or seperate actual...

I hope the OP is learning from...

This looks like a (sample-)question for an exam. The answer is:

- take a tail log backup

- restore the last FULL backup (using NORECOVERY)

- restore the last DIFF backup (using NORECOVERY)

-...

Using "SELECT * " in a view has a caveat you need to be aware of or it will bite you in the ***. A change in columns of the...

What number is resturned when you execute:

SELECT COUNT(*) FROM {your_table}

What number is returned when you execute:

SELECT COUNT({your_xml_column}) FROM {your_table}

What number is returned when you execute:

SELECT COUNT(CAST({your_xml_column} as NVARCHAR(4000))) FROM {your_table}

Good question, but I had it wrong. I was thinking an UPDATE uses the special 'deleted' and 'inserted' tables. And therefor concluded the INDENTITY_INSERT also applies to UPDATE. I now...

The official Microsoft manual for the maintenance plan (using the wizard) is here: http://msdn.microsoft.com/en-us/library/ms191002.aspx. If you google a bit you can find many other step-by-step descriptions and also find about...

You can put the execution of your DIFF backup statement inside a TRY...CATCH block. Check in the CATCH block if the error message is the missing FULL backup. If so,...

Your problem basically lies within the design of the table. If possible you should normalize the table and remove the 'duplicate' columns (User1, User2) and replace them with a single...