Viewing 15 posts - 6,241 through 6,255 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 7, 2015 at 2:43 am
MMartin1 (4/6/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 2, 2015 at 10:27 am
Edit: nm, misread
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 2, 2015 at 10:26 am
I suspect that's during the startup process, given the tiny amounts of memory. If so, just ignore it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 2, 2015 at 7:13 am
Viewing 15 posts - 6,241 through 6,255 (of 49,552 total)