Viewing 15 posts - 18,781 through 18,795 (of 19,560 total)
mmartin1 (12/1/2009)
Try tuning you indexes, NOLOCK is guaranteed to read uncommitted transactions but not necessarily guaranteed to improve performance.
Not to mention the other problems that NOLOCK can cause (double reads...
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 11, 2009 at 12:53 pm
Here's an article about the very topic (table partitioning, reindexing, and VLDBs)
http://www.mssqltips.com/tip.asp?tip=1200
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 11, 2009 at 12:47 pm
In addition to the why that Jeff posted, are you really sure you want to do this? 52 partitions for one table, have you considered the implications - what...
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 11, 2009 at 12:44 pm
How about putting your query into a proc that requires an input parameter?
Then you could do something along the lines of
select LEFT(@string,@left)
Inside 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 11, 2009 at 12:21 pm
Besides the system databases, don't forget any certificates, master keys or otherwise that need to be backed up separately.
The idea is to be able to get back up and running...
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 11, 2009 at 12:06 pm
At least he retracted and clarified.
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 11, 2009 at 12:03 pm
That makes much more sense
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 11, 2009 at 12:02 pm
In SSMS you can use Database Diagrams. Expand your database, right click the Folder called Database Diagrams and select "New Database Diagram."
Erwin also has a good modeling tool. ...
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 11, 2009 at 10:46 am
To back up what Jonathan said, here is an article that talks about Lock Pages in Memory:
http://blogs.technet.com/askperf/archive/2008/03/25/lock-pages-in-memory-do-you-really-need-it.aspx
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 11, 2009 at 10:40 am
jwa082276 (12/11/2009)
However, in the month I will be moving my data to our san system. I will create one volume for each lun I create; so...
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 11, 2009 at 10:28 am
The last 1000 posts have come much more rapidly than I would have thought with all the holidays.
Steve can have #10,000 if he beats everybody to it:-P
Or should the Thread...
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 11, 2009 at 10:24 am
crookj (12/11/2009)
Humorous(Watching the single winning Cleveland Browns defeat the so called World Champions - Pittsburgh Steelers.) 😛
Yes, yes indeed that is humorous:-D. Too bad my team isn't faring...
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 11, 2009 at 10:20 am
Those steps are a heirarchical structure for getting to your database server. The database engine is the guts of your RDBMS. It does not grow - it 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
December 11, 2009 at 9:18 am
swallow
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 11, 2009 at 9:12 am
Thanks Chris for following up.
As for the requirements and desired output, Chris was spot on. If this does not do exactly what you envisioned - we need to have...
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 11, 2009 at 9:08 am
Viewing 15 posts - 18,781 through 18,795 (of 19,560 total)