Viewing 15 posts - 19,051 through 19,065 (of 19,560 total)
this may work
just a quick and dirty
With Core as (select top 50
are.client_code,
...
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
November 23, 2009 at 11:22 am
DataDictionary
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
November 23, 2009 at 10:29 am
What has worked for me is to change the excel column data type to text and then import to a varchar field.
Another option is to use MS Access as a...
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
November 23, 2009 at 10:24 am
Bought two print copies and the e-book. The book is well worth the price. Bought mine during the week of PASS from the web and received them the...
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
November 23, 2009 at 10:21 am
Saravanan_tvr (11/23/2009)
My Dear Experts,now our clients compliant appliactions are very slow while thay are saving the entries ,
It would seem that you would get the biggest bang for your...
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
November 23, 2009 at 10:14 am
Bob Hovious 24601 (11/23/2009)
I also saw...
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
November 23, 2009 at 10:09 am
Steve Jones - Editor (11/20/2009)
Now I want a steak for dinner, but my wife put a turkey in 🙁
Boycott dinner - tell her Thanksgiving is next week 😉
Or dress the...
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
November 20, 2009 at 4:38 pm
I have not experienced that issue with Server2000 or Server2003. That is not to say that the issue does not exist. Since there was a specific fix for...
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
November 20, 2009 at 4:08 pm
Oh, and one more podcast by Brent Ozar
http://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/
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
November 20, 2009 at 4:04 pm
syedkamranfaisal (11/20/2009)
I want know if there is any performance tuning parameters with...
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
November 20, 2009 at 4:02 pm
Yum, just finished my prime rib - that hit the spot after all the carnivore talk. Late Lunch due to meetings during lunch - had to get something substantive.
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
November 20, 2009 at 3:54 pm
GSquared (11/20/2009)
Steve Jones - Editor (11/20/2009)
One other thing I'd...
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
November 20, 2009 at 12:00 pm
It is normal for a query to take longer on the first run until the plan is cached.
Rebuild statistics is not always necessary as part of the rebuild indexes maintenance.
And...
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
November 20, 2009 at 11:58 am
Gianluca Sartori (11/20/2009)
CirquedeSQLeil (11/20/2009)
All this talk of steak and I'm ready for a Prime Rib.What's a "Prime Rib", Jason?
http://gourmetmeatman.com/ROASTS.aspx
It's listed as a Roast, but it is cut like a steak....
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
November 20, 2009 at 10:31 am
Lynn Pettis (11/20/2009)
Gianluca Sartori (11/20/2009)
My steak recipe is the shortest ever:
* volcano hot...
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
November 20, 2009 at 10:14 am
Viewing 15 posts - 19,051 through 19,065 (of 19,560 total)