Viewing 15 posts - 3,286 through 3,300 (of 7,191 total)
While the query is running, use the sys.dm_os_waiting_tasks view to determine the wait type for the query. Do that several times, just in case it's waiting on lots of...
December 18, 2014 at 3:55 am
One way (not necessarily the most efficient) is to join v back to table_name on v.letter = left(table_name.name) before you do the UNION.
John
December 17, 2014 at 9:26 am
Is the Distributed Transaction Coordinator running on both servers?
John
December 15, 2014 at 8:40 am
And it's definitely a named instance? The SQL Server Browser service only resolves ports for named instances.
John
December 15, 2014 at 7:33 am
What sort of data is in the database? If it's mainly text, the backup will compress well. If it's mainly LOB data, it won't.
John
December 12, 2014 at 10:04 am
That looks about right, Sean. I was just about to suggest that the last query in the original post was nearly there - it just needs the IN changed...
December 12, 2014 at 9:43 am
The first thing to do is copy and paste the error message into your favourite search engine. When I did that, the first result was a blog that looked...
December 12, 2014 at 9:34 am
BWFC (12/12/2014)
John Mitchell-245523 (12/12/2014)
BWFC (12/12/2014)
that could be we TUPE straight out through the door.
I'm no lawyer, but as I understand it, TUPE protects you from any changes that are made...
December 12, 2014 at 7:45 am
BWFC (12/12/2014)
that could be we TUPE straight out through the door.
I'm no lawyer, but as I understand it, TUPE protects you from any changes that are made as a direct...
December 12, 2014 at 7:30 am
Alex
Yes, that did exist, possibly up to SQL Server 2000. As far as I know, you can't do it any more. Too much of a security risk, I...
December 12, 2014 at 4:16 am
If it's a one-off copy-and-paste into Excel, you can also type a "'" (single quote) into the cell and append the number on to that. That will have the...
December 12, 2014 at 3:48 am
You need to copy and paste the plan into a text file and save it with a .sqlplan extension. You can then open it in graphical form in SSIS.
John
December 11, 2014 at 9:28 am
Never seen that before. But if I had to guess, I'd say that the backup that was made to that file was interrupted and didn't finish.
John
December 11, 2014 at 9:19 am
No, it will only show what backup set(s) are on the backup device (file). Have a read of the RESTORE topic in Books Online.
John
December 11, 2014 at 9:14 am
What happens if you do [font="Courier New"]RESTORE HEADERONLY FROM DISK = 'MyFile'[/font], where MyFile is the path to and name of your backup file?
John
December 11, 2014 at 9:08 am
Viewing 15 posts - 3,286 through 3,300 (of 7,191 total)