Viewing 15 posts - 39,631 through 39,645 (of 49,552 total)
You can try the default trace. Depending on the activity on your system it may go back 2 weeks or it may not. The default trace is made up of...
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 20, 2009 at 6:00 am
Get them back or know who dropped 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
April 20, 2009 at 5:42 am
john_chrome (4/20/2009)
Do you think this fashion of while loop might have any performance improvement over cursor.
Minimal, if at all.
Why can't you do the identifying of bad records and updating of...
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 20, 2009 at 5:31 am
Tim Walker (4/20/2009)
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 20, 2009 at 5:08 am
660 MB of data's a fair bit. I wouldn't be surprised if the time difference is due to the network. That's a lot of data to be streaming out.
What's 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
April 20, 2009 at 4:44 am
This kb may be of interest, even though it's supposedly just for SQL 7 and 2000.
http://support.microsoft.com/kb/314648
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 20, 2009 at 4:43 am
Table variables, just like temp tables are allocated space in TempDB. SQL tries as much as possible to keep them in memory (in the data cache) because it knows that...
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 20, 2009 at 4:34 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic700470-391-1.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
April 20, 2009 at 4:14 am
Is there any blocking?
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 20, 2009 at 3:19 am
Just a thought, can you run a consistency check on the databases on that server?
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
Any errors in the SQL Error log?
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 20, 2009 at 3:18 am
Try this
exec sp_msforeachdb 'use [?] exec sp_spaceused'
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 20, 2009 at 3:17 am
As far as I'm aware, and contrary to what BoL seems to be saying, there's no way, within SQL to get at the decrypted text.
Do a google search 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 20, 2009 at 1:25 am
Lee From Bangalore (4/19/2009)
Is it securable to having the sysadmin roles to that users?
Absolutely not. By giving sysadmin, you're giving them rights to do anything on SQL. Drop databases, delete...
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 20, 2009 at 1:13 am
The trace wait is from running profiler. Don't run profiler (GUI) on a busy production system. Use the server-side traces instead.
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 20, 2009 at 1:06 am
Lowell (4/19/2009)
does truncating force a rebuild(resetting?) on statistics if auto-update statistics is ON?
No. Truncate doesn't affect the rowmodcnt/colmodcntrs at all.
but since truncate is not logged...
Logging and stats have nothing 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 20, 2009 at 1:03 am
Viewing 15 posts - 39,631 through 39,645 (of 49,552 total)