Viewing 15 posts - 5,221 through 5,235 (of 49,552 total)
Start by notifying anyone relevant that the data has probably been lost, because that's the likely outcome without backups.
What exactly are you trying to do and what are the error...
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
July 22, 2015 at 3:56 am
Restore from your last good backups. That's the only reliable solution.
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
July 22, 2015 at 3:01 am
Table definitions, index definitions and the actual execution plan please?
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
July 22, 2015 at 2:53 am
Lynn Pettis (7/21/2015)
Stephanie Giovannini (7/21/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
July 22, 2015 at 2:53 am
Rod at work (7/21/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
July 22, 2015 at 2:47 am
Parameter sniffing, or more correctly lack thereof. google: Grant Fritchey parameter sniffing, you should get one of his articles.
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
July 21, 2015 at 9:40 am
What exactly do you mean by 'won't run'?
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
July 21, 2015 at 7:50 am
Powershell should have a method. It's not really something that you'd do within a database.
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
July 21, 2015 at 7:39 am
If this database is critical, don't fiddle with writepage or similar, you could easily make things worse. Export what data you can, recreate the DB, get the system up and...
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
July 21, 2015 at 7:00 am
If the output listed is all that checkDB returned, this is not repairable.
Restore from your last good backup. If you don't have a backup. Script the objects out (tables,...
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
July 21, 2015 at 6:43 am
The info in the transaction log will be the same no matter if the admin console is used, management studio or anything else. The host name won't be there. The...
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
July 21, 2015 at 6:39 am
There's nothing you can tune with that query. You're telling SQL to create a duplicate copy of the table, so it has to read the existing table from disk (if...
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
July 21, 2015 at 6:32 am
Why do you think hash joins are a problem?
http://www.sqlservercentral.com/articles/Performance+Tuning/115825/
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
July 21, 2015 at 6:26 am
To be honest, that's one of the fairly safe upgrades. 2000 -> anything is one that's very likely to have something break. Anything -> 2014 needs testing because of the...
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
July 20, 2015 at 8:03 am
Yes, because without quotes that's getting treated as a mathematical expression, specifically as two numbers being subtracted from 2015.
2015 - 07 - 20 = 1988
The calculated value of 1988 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
July 20, 2015 at 7:56 am
Viewing 15 posts - 5,221 through 5,235 (of 49,552 total)