Viewing 15 posts - 6,241 through 6,255 (of 49,571 total)
No. LSNs are never reused, they're unique within the database.
If an LSN ever reset to a lower value it would result in the database being suspect and needing a...
April 7, 2015 at 2:49 am
I would argue with the premise here, not the query.
A non-online DB is not a call to run CheckDB. If a database is OFFLINE or RESTORING, there's nothing wrong with...
April 7, 2015 at 2:43 am
MMartin1 (4/6/2015)
April 7, 2015 at 2:37 am
??
A database doesn't go into restoring after an attach, It'll go online.
What are you doing, what behaviour are you seeing?
April 7, 2015 at 2:30 am
Grant Fritchey (3/31/2015)
Steve Jones - SSC Editor (3/31/2015)
Grant Fritchey (3/31/2015)
I use semicolons on terminators for all my statements. Everyone should.
You do or Prompt does it for you?
Well, Prompt does it...
April 5, 2015 at 11:04 am
That query is about as optimal as it will get (and the OR will probably perform about the same), the cause of the poor performance is likely missing indexes. Can...
April 5, 2015 at 11:02 am
ScottPletcher (4/2/2015)
You can't name the indexes yourself unless you insure they're unique. It's a pain, but using dynamic SQL you can do it.
That's the case for constraints, not for...
April 2, 2015 at 10:31 am
dwilliscp (4/1/2015)
I have not run across a problem.. yet.. but does this problem also cover indexes on temp tables?
No. Index names are only unique within the table. You can...
April 2, 2015 at 10:29 am
Gianluca didn't suggest killing the spid, he suggested identifying it. Once you know what the lead blocker is running, you have a chance to fix the problem.
April 2, 2015 at 10:27 am
I suspect that's during the startup process, given the tiny amounts of memory. If so, just ignore it.
April 2, 2015 at 10:03 am
Hang on, you work for Microsoft, on the Redmond campus and you're asking people here for help?
April 2, 2015 at 8:20 am
To start, Microsoft support won't help you. They don't do data recovery, they're not allowed to try.
You're probably out of luck.
What happens when you try to attach the database to...
April 2, 2015 at 8:08 am
In other words, you shouldn't use WITH OVERRIDE unless you're specifying an invalid value or one outside of recommended ranges and know exactly what you're doing.
April 2, 2015 at 7:25 am
Lowell (4/2/2015)
start with using SSMS: in object exporter, right click on a server and choose "Activity Monitor"
SQL Server 8.00.76 is SQL Server 2000 RTM (no service packs). Enterprise Manager is...
April 2, 2015 at 7:13 am
Viewing 15 posts - 6,241 through 6,255 (of 49,571 total)