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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 16, 2010 at 3:26 pm
GT-897544 (2/16/2010)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 16, 2010 at 2:38 pm
Alvin Ramard (2/16/2010)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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:...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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,...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 15, 2010 at 8:16 am
Viewing 15 posts - 7,066 through 7,080 (of 14,953 total)