Viewing 15 posts - 16 through 30 (of 39 total)
I'm wondering just what the benefit is to filegroups when your data is stored on a SAN or NetApp appliance? I believe I read something about a benefit when...
May 12, 2011 at 2:13 pm
Not sure this makes sense, but I received the "incorrectly formatted" error after I backed up databases with the same names on a different instance to the same location.
August 3, 2010 at 7:42 am
Have you found a solution to this issue?
July 7, 2010 at 2:51 pm
GilaMonster (5/26/2010)
don.schaeffer (5/25/2010)
May 26, 2010 at 7:34 am
I've just been testing fragmentation on a table that has a clustered index on a guid (ouch!), not my design. But I've found that with an appropriate fill factor,...
May 25, 2010 at 3:48 pm
If there are transactions involved locks may be retained on tables from previous statements. Even though the second spid might be selecting from table b it may still have...
April 9, 2010 at 3:45 pm
This script might get what you want:
select
WaitTime = cast( textdata as xml ).value( '/blocked-process-report[1]/blocked-process[1]/process[1]/@waittime','varchar(20)' ),
BlockingQuery = cast( textdata as xml ).value( '(/blocked-process-report/blocking-process/process/inputbuf)[1]','varchar(200)'),
BlockingSpid = cast( textdata as xml ).value( '/blocked-process-report[1]/blocking-process[1]/process[1]/@spid','varchar(20)'...
April 9, 2010 at 2:05 pm
You can use powershell to execute a script on multiple servers. This article shows how to do this, populating an excel worksheet with information on failed jobs:
September 8, 2009 at 1:26 pm
Table with self references seem to cause an infinite loop in this script. I added "where S1.name SO.Name" to the table population query to avoid this.
May 27, 2009 at 2:53 pm
The last line of the where clause reads:
AND ((a.user_seeks + a.user_scans + a.user_lookups) = 0 OR a.user_updates = 0)
I think "OR a.user_updates = 0" should be removed. For example,...
January 30, 2009 at 12:50 pm
I'm curious how many people verify their backups. I found that step can take twice as long as performing the backup itself.
January 13, 2009 at 9:51 am
You could replace the insert statement with this one to get the correct table schemas and avoid those errors. We too use multiple schemas, for organizational purposes.
INSERT INTO @FKTable...
January 8, 2009 at 10:49 am
Jonathan, thanks for looking at this. No, I haven't resolved it.
Client_Id is an integer column; there's an index on it:
CREATE NONCLUSTERED INDEX [Employees_Client_id] ON [dbo].[Employees]
(
[Client_ID] ASC,
[DivID]...
January 6, 2009 at 2:44 pm
Sorry, I edited my post. My xml was getting eaten when I posted so I replace the close ">" with right bracket "]"
December 5, 2008 at 8:23 am
I don't know whether to always believe the blocked process report. At times I see lots of purported blocking like this, where one select statement is supposedly blocking another....
December 5, 2008 at 8:02 am
Viewing 15 posts - 16 through 30 (of 39 total)