Viewing 15 posts - 18,661 through 18,675 (of 19,560 total)
The table scan occurs if the Engine determines that a table scan will be more efficient. If you have null values or empty strings in your column, they will...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 18, 2009 at 10:16 am
With the server being virtual, the question may be pertinent to ask the business managers if they are referring specifically about the VM.
Can one clone a VM? Yes. ...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 18, 2009 at 10:07 am
Alvin Ramard (12/18/2009)
Luke L (12/18/2009)
SQL Azure?Yeah, that's what I meant.
My head is in the clouds today. Roughly 5 more hours before 2 week vacation starts.
Punny
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 18, 2009 at 9:56 am
Nice review, thanks for the info Jeff.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 18, 2009 at 9:54 am
You can run profiler, that will more or less create a trace that you can use for playback. As far as testing the app though - it wouldn't catch...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 18, 2009 at 9:50 am
The only MLB park I have been to happens to be Coors Field. Rockies Pirates game about 5.5 yrs ago. That is a really nice ballpark with great...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 18, 2009 at 9:47 am
Excel and Access with custom replication to your iphone?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 18, 2009 at 8:50 am
At this point, it would be the archaic method of interviewing the users. Watch what they enter and verify the results. Repeat the process when testing the upgrade.
Alternative,...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 18, 2009 at 8:49 am
Please post the table structure for the tables referenced in the proc.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 18, 2009 at 8:44 am
Thanks for the feedback.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 18, 2009 at 8:38 am
Grant Fritchey (12/18/2009)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 18, 2009 at 8:37 am
SQL 2K8
Partitioned tables
Clustered
Mirrored
200Tb SAN
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 18, 2009 at 8:35 am
Paul White (12/17/2009)
Jeff Moden (12/17/2009)
Dunno if you're making a joke, but your's has a little red "X" and that's it.
Oh. No - not intending a joke - but I...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 17, 2009 at 10:51 pm
satisfaction
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 17, 2009 at 10:49 pm
I think it is a nice combination of both. There is an inborn desire to break things, or take things apart to see how it might work. Teaching...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 17, 2009 at 10:49 pm
Viewing 15 posts - 18,661 through 18,675 (of 19,560 total)