Viewing 15 posts - 33,016 through 33,030 (of 49,552 total)
Gianluca Sartori (5/7/2010)
Lynn Pettis (5/7/2010)
Our PhD candidate at work.Hope I wasn't too rude.
This guy has the ability to drive me insane (maybe it's his signature???) .
You and me both....
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
May 7, 2010 at 10:28 am
The Dixie Flatline (5/7/2010)
afaik? = "As far as I know?"
Yup.
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
May 7, 2010 at 10:27 am
CirquedeSQLeil (5/7/2010)
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
May 7, 2010 at 10:27 am
karthikeyan-444867 (5/7/2010)
I don't have the access to open 'profiler'.
Why not? Insufficient permissions? If you're testing your optimisations on a dev system, there's no reason you shouldn't have ALTER TRACE rights....
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
May 7, 2010 at 9:56 am
When the query(s) have no single optimal plan. One example is when you have severe parameter sniffing, data skew or similar.
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
May 7, 2010 at 7:53 am
GregoryF (5/7/2010)
Is that new to 2008? I know in 2005 the compatibility is left at the original. I just thought 2008 limited attaches to 200 and later
I'm not...
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
May 7, 2010 at 7:13 am
GregoryF (5/7/2010)
In which case, just attach it to 2008 and see what compatibility mode it is, if you don't have 2008 in your enterprise, then attach to 2005.
Problem with 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
May 7, 2010 at 6:58 am
100%. SQL tries to run a query as fast as possible, so it will try to use a CPU to 100% for the duration of the query. If it doesn't,...
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
May 7, 2010 at 6:52 am
Lowell (5/7/2010)
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
May 7, 2010 at 6:47 am
GregoryF (5/7/2010)
What would be the point? You could only even attempt this for a detatched DB.
Likely that's exactly the point, to tell what version a detached DB came from...
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
May 7, 2010 at 6:45 am
You could try opening it in a hex editor and manually cracking the value out of the database header page (9th page of 8kb each) and getting out the 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
May 7, 2010 at 6:41 am
Filter your trace. If you're just interested in an object being dropped, just use the Objects: Object Dropped event
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
May 7, 2010 at 6:32 am
Don't understand what you're asking.
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
May 7, 2010 at 5:10 am
You shouldn't be using nolock anyway, not as a 'default' solution. It has side-effects. http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx
Switch traceflag 1222 on. That will result in a deadlock graph been written to 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
May 7, 2010 at 4:27 am
Ratheesh.K.Nair (5/7/2010)
Then how can i create a new integration service package there in that server??
Development work should be done on development workstations, ie desktops, not on the server directly. You...
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
May 7, 2010 at 3:02 am
Viewing 15 posts - 33,016 through 33,030 (of 49,552 total)