Viewing 15 posts - 24,436 through 24,450 (of 49,552 total)
Trigger?
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
August 4, 2011 at 4:33 pm
Please note: 4 year old thread.
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
August 4, 2011 at 4:32 pm
george sibbald (8/4/2011)
Gail, don't start this 'beat george to the post' thing again :w00t:
Ok, I'll go to bed. <grumble>
It is after midnight so....
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
August 4, 2011 at 4:23 pm
A bit more detail on what you mean by 'doesn't allow me' would be useful at this point.
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
August 4, 2011 at 4:12 pm
george sibbald (8/4/2011)
Craig Farrell (8/4/2011)
It's been proven that you can *waltz* through American security even after 9/11 with:
...- 2 lbs of C4 ( shaped as/in your flipflops......
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
August 4, 2011 at 4:07 pm
You can, but it will continue the rollback after the server restart, with your database offline and unavailable (unless you're using enterprise edition, in which case the database will be...
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
August 4, 2011 at 4:06 pm
Nothing.
Putting an appropriate clustered index in place instead of a heap might save a second or 2, maybe.
Or you could request hardware upgrades. A faster network, more memory 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
August 4, 2011 at 3:34 pm
Nope. You're asking for every column, every row. That's a table scan, there's no faster way to fetch the entire table.
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
August 4, 2011 at 3:29 pm
Not natively in SQL.
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
August 4, 2011 at 3:26 pm
Grant Fritchey (8/4/2011)
I have to ask, why no backups?
What, you didn't get the news? August has been declared a 'no backup' month. </sarcasm>
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
August 4, 2011 at 3:20 pm
If it's the active node you're rebooting, yes.
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
August 4, 2011 at 3:06 pm
Lowell (8/4/2011)
and make sure there is a semicolon in front of the WITH,
Make sure that the statement before the WITH is terminated with a ;. A CTE declaration...
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
August 4, 2011 at 3:02 pm
Something you need to check with them, if the database fails catastrophically at (say) 14h36 one day, what's the best restore they can do? (properly configured SQL backups can, in...
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
August 4, 2011 at 2:21 pm
Start with these:
http://msdn.microsoft.com/en-us/library/ms186865.aspx
http://msdn.microsoft.com/en-us/library/ms187510.aspx
http://msdn.microsoft.com/en-us/library/ms191304.aspx
http://msdn.microsoft.com/en-us/library/ms186858.aspx
http://msdn.microsoft.com/en-us/library/ms177429.aspx
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
August 4, 2011 at 2:07 pm
Specify the path and name of the log file that you restored.
p.s. You need to look at this 'backup' solution. Copying mdf and ldf files is NOT how SQL...
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
August 4, 2011 at 1:49 pm
Viewing 15 posts - 24,436 through 24,450 (of 49,552 total)