Viewing 15 posts - 16,336 through 16,350 (of 49,552 total)
Not enough information. Need to see what and how you set @Query.
Also, the parameter definitions would be one variable, not two, and you're not setting the parameters to anything.
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
October 1, 2012 at 8:18 am
I read the article. It would appear that I either didn't emphasise some things to Tony or he chose to ignore them. 😀
p.s. If any DBA ever told me they...
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
October 1, 2012 at 7:12 am
SQLCrazyCertified (9/26/2012)
· Determine where the current transaction log resides and write trans log to this file directory.
Why do you want 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
October 1, 2012 at 7:11 am
Well, if that 'realisation' happens to SQL Server DBAs there will be more optimisation work than ever for the SQL Server consultants.
Rebuilding indexes in SQL Server is not a waste...
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
October 1, 2012 at 6:44 am
I wouldn't use that function. The loops will make it very slow.
Try this one: http://www.sqlservercentral.com/articles/Tally+Table/72993/
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
October 1, 2012 at 6:26 am
Nope.
Without any errors saying why CheckDB went for tablock (which is not default), not going to be possible to figure this out. Something prevented the creation of the database snapshot,...
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
October 1, 2012 at 6:21 am
Err... 1433 being the default port for SQL Server and 1434 being the UDP broadcast port?
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
October 1, 2012 at 4:07 am
That code will only recover deleted records that are still in the active portion of the transaction log (ie deleted since the last log backup or checkpoint). Since you want...
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
October 1, 2012 at 3:47 am
I take it you missed the section in that article about not shrinking the log then.
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
October 1, 2012 at 3:44 am
That's a very old list (2007 thread). Steve's added several since then.
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
October 1, 2012 at 3:43 am
Restore a backup from before the rows were deleted and copy them out. There is no other way, SQL doesn't keep deleted rows around just in case someone needs them.
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
October 1, 2012 at 3:40 am
No error messages about trying to create a snapshot? No error messages about failing to create a snapshot? About CheckDB being unable to run online?
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
October 1, 2012 at 3:39 am
Yes, absolutely it's normal.
No user process created these. They were spawned when SQL started and they won't terminate until the SQL instance stops. That's why they have such huge wait...
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
October 1, 2012 at 3:38 am
Or you could use a string splitter function and then join to the results of that. Less risky than dynamic SQL (not vulnerable to SQL injection)
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
October 1, 2012 at 2:47 am
Backups don't change file sizes.
I suspect you may need to read this: Managing Transaction Logs[/url]
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
October 1, 2012 at 2:16 am
Viewing 15 posts - 16,336 through 16,350 (of 49,552 total)