Viewing 15 posts - 14,191 through 14,205 (of 19,560 total)
vijay.s (5/6/2010)
I'd appreciate some expert assistance on this.
I am looking to produce the third column given the first two columns in
straight SQL without using cursors. Here is 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
May 6, 2010 at 1:39 pm
praviii... (5/6/2010)
different editions available
1.developer
2.standard
3.enterprise
4.web
5. workgroup
and also the platform which i shouls...
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
May 6, 2010 at 1:35 pm
I think you will get great mileage out of reading an article by Jeff Moden on the subject.
http://www.sqlservercentral.com/articles/T-SQL/68467/
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
May 6, 2010 at 1:33 pm
Jack Corbett (5/6/2010)
Steve Jones - Editor (5/6/2010)
Jack Corbett 1533
Jack Corbett ...
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
May 6, 2010 at 1:29 pm
As Paul said, this really isn't too big of a database. Knowing your big tables and where your sticking points are when doing the maintenance would be the keys...
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
May 6, 2010 at 1:26 pm
PaulB-TheOneAndOnly (5/6/2010)
Question is,...
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
May 6, 2010 at 1:24 pm
I think you may have an Issue with Spotlight. Those page counts for the Spotlight spid are quite high. It has caused the system to allocate 4.7Gb of...
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
May 6, 2010 at 1:22 pm
crookj (5/6/2010)
CirquedeSQLeil (5/6/2010)
bcsims 90437 (5/6/2010)
El Paso? Salsa... it's almost lunchtime.Jalapenos
Chili Cookoff (New Mexico or Arizona style!)
Joe
If we go the chili cookoff rather than nacho route, 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
May 6, 2010 at 1:17 pm
jcrawf02 (5/6/2010)
ask people for topics they'd like to see, there may be things they're working on that they can use help with.
That is a great tip.
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
May 6, 2010 at 1:15 pm
dbowlin (5/6/2010)
CirquedeSQLeil (5/6/2010)
bcsims 90437 (5/6/2010)
El Paso? Salsa... it's almost lunchtime.Jalapenos
Mouth watering.....eye watering.
Sour Cream
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
May 6, 2010 at 1:13 pm
Lynn Pettis (5/6/2010)
Jeff Moden (5/5/2010)
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
May 6, 2010 at 1:12 pm
Not fully sure if it will work. MS recommend using Outlook 2000 for a few bug fixes when using a MAPI client - even for SQL 2005.
I think 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
May 6, 2010 at 1:05 pm
rafael_si (5/6/2010)
I work in a company here in Brazil, and we have a Data Warehouse. Well, at the beggining was easy to mantain this database indexed, because it was...
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
May 6, 2010 at 12:56 pm
No. Pre-execute cannot be skipped either. It is a part of the run-time. If the query is doing nothing more than a Clustered Index seek, and it...
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
May 6, 2010 at 12:49 pm
There are plenty of things within SQL Server to entertain (err time sink) one's self as well. Find something within SQL server to learn or make better. Teach...
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
May 6, 2010 at 12:46 pm
Viewing 15 posts - 14,191 through 14,205 (of 19,560 total)