Viewing 15 posts - 33,496 through 33,510 (of 49,552 total)
It just means that the connection is open but is running no queries at this point in time. It's not a 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
March 15, 2010 at 2:07 pm
Alvin Ramard (3/15/2010)
Anybody else see a problem with this statement?DECLARE @selectDate = getdate()-365
Leap years are vastly overrated.
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
March 15, 2010 at 2:06 pm
Which column(s) are the primary key of this table?
This should be easy enough to fix with some straightforward updates, but need the pk (or unique column) to identify the row....
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
March 15, 2010 at 1:57 pm
mathias-ruehn (3/15/2010)
i tried to backup / restore vor migration,but got the same message
Backup/restore, detach/attach will have the same result, a database in SQL 2008 format.
database engineer said,
that this error occurs...
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
March 15, 2010 at 1:50 pm
Rajan John-243593 (3/12/2010)
also, will running profiler remotely pull trace data to the remote machine and then push back to the server to write on the server?
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
March 15, 2010 at 9:58 am
Lynn Pettis (3/15/2010)
Grant Fritchey (3/15/2010)
Lynn Pettis (3/15/2010)
Grant Fritchey (3/15/2010)
GSquared (3/15/2010)
Grant Fritchey (3/15/2010)
Oh cool, tossed under another bus. Thanks Alvin.
What year? (My birthday was yesterday, so I'm curious as 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
March 15, 2010 at 9:56 am
Bad idea. Using the profiler GUI at all on a production server is a bad idea.
http://scarydba.wordpress.com/2008/12/18/profiler-research/
http://scarydba.wordpress.com/2009/10/28/snags-with-profiler-gui/
Rather use the server-side trace and save the trace to a fast local drive.
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
March 15, 2010 at 9:55 am
I'm going to assume you didn't read the article.... Please do 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
March 15, 2010 at 6:48 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
March 15, 2010 at 4:17 am
That's a bit of a vague question. Can you be more specific as to what you're looking for? Also, is this a 24x7 uptime DB or do you have large...
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
March 15, 2010 at 4:13 am
By 'indexing' do you mean index creation? Rebuilding indexes? Something else?
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
March 15, 2010 at 1:59 am
Change the backup so it goes to a local drive, will be much faster. Once the backup has completed then copy it remotely. That should decrease the time that 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
March 15, 2010 at 1:57 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/Topic882719-360-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
March 15, 2010 at 1:56 am
What error were you getting when trying to query that on SQL 2000?
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
March 15, 2010 at 1:54 am
That was an undocumented table and looks like it's not in SQL 2005.
You shouldn't be trying to use it anyway. Rather use one of the system views (depending what you're...
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
March 14, 2010 at 9:33 am
Viewing 15 posts - 33,496 through 33,510 (of 49,552 total)