Viewing 15 posts - 7,066 through 7,080 (of 14,953 total)
GT-897544 (2/16/2010)
Elliott W (2/16/2010)
Basic Troubleshooting 101:
1. Find out WHY you have the problem in the first place
It is clear that GT-897544 has very little real...
February 16, 2010 at 3:26 pm
GT-897544 (2/16/2010)
February 16, 2010 at 2:56 pm
GT-897544 (2/16/2010)
GilaMonster (2/16/2010)
GT-897544 (2/16/2010)
And by dbcc I mean with “DBCC CHECKTABLE” REPAIR_REBUILD. If that did not complete successful after two or three times I would then use “REPAIR_ALLOW_DATA_LOSS” option.
Oh for...
February 16, 2010 at 2:45 pm
This is what I can find on the subject:
http://support.microsoft.com/kb/919155
DBCC CHECKDB does take a lock on tables. The above is about DBCC itself recording a timeout, but in a system...
February 16, 2010 at 2:38 pm
Alvin Ramard (2/16/2010)
February 16, 2010 at 2:29 pm
CirquedeSQLeil (2/16/2010)
Chad Crawford (2/16/2010)
RBarryYoung (2/16/2010)
(if that doesn't make sense, then note closely the dates & times in...
February 16, 2010 at 2:21 pm
SuzDBA (2/16/2010)
Server A will have 3 Databases: DB1, DB2, DB3
Server B will have 3 Databases:...
February 16, 2010 at 2:20 pm
GT-897544 (2/16/2010)
sqldba551 (2/16/2010)
As last 3 days back my server got hardware failure,my databases went into suspect mode,i have tried to take it to online by SET IT...
February 16, 2010 at 2:18 pm
GT-897544 (2/15/2010)
GSquared (2/15/2010)
Bru Medishetty (2/15/2010)
select @@version
and look at the output, where the end part shoes if nothing if it's a physical server and if it's on...
February 16, 2010 at 6:14 am
There are a few different ways to do this. The one I usually find works best is to create a table of the weeks you want to query against...
February 15, 2010 at 2:52 pm
Bru Medishetty (2/15/2010)
select @@version
and look at the output, where the end part shoes if nothing if it's a physical server and if it's on a Virtual...
February 15, 2010 at 2:50 pm
I can't tell for sure without some sample data, but it looks to me like the CTE should end up with an infinite loop in it based on that Join...
February 15, 2010 at 1:31 pm
Check out "DateAdd" in Books Online. You can add -2 years to get what you're looking for.
February 15, 2010 at 8:19 am
You should be able to view the query in the report properties.
If not, run a trace and open up the report. If the trace includes the text for batches,...
February 15, 2010 at 8:18 am
My prior employer worked on the NYSE schedule, and they have the day off. (The only thing I really miss about that job was the huge number of days...
February 15, 2010 at 8:16 am
Viewing 15 posts - 7,066 through 7,080 (of 14,953 total)