Viewing 15 posts - 3,556 through 3,570 (of 5,843 total)
I use 'generated' TSQL like that all the time but never thought to make the leap and intermix straight/generated TSQL in a CTE like that. Oh the possibilities!! ...
March 10, 2011 at 9:16 am
I should mention that if you are going to upgrade your SQL 2005 installation you should probably go straight to the latest service pack and cumulative update. Don't want...
March 8, 2011 at 7:45 am
snivas (3/3/2011)
I have a A/P cluster server running with SQL Server 2005 RTM and allocated min memory is 8GB and max memory is 24 GB.(Total memory 32GB)
Today SQL...
March 8, 2011 at 7:06 am
Please script out your tempdb database (righ-click on the database icon in SSMS and Script Database As Create To New Query window.
Maybe you just have a tempdb that...
March 7, 2011 at 12:03 pm
Jeff Moden (3/7/2011)
TheSQLGuru (3/7/2011)
March 7, 2011 at 8:37 am
There are VERY few scenarios where you want to consider table variables over temp tables: VERY high volume executions where temp-table-driven recompiles are causing issues, logging situations (table vars keep...
March 7, 2011 at 6:53 am
Given the question the OP asked, I imagine he/she has little ability/knowledge about query plans and how statistics are used to generate them. Time for some reading, since this...
March 7, 2011 at 6:45 am
1) 16 files is almost certainly unnecessary, and unless they are on separate spindles could be causing IO performance problems due to excessive head thrashing.
2) why no autogrowth on those...
March 7, 2011 at 6:38 am
Your statement is correct cloud9.
March 7, 2011 at 6:31 am
Explicit cursors can crush your actual execution plan (and thus actual IO in profiler) too.
March 4, 2011 at 9:31 am
1) TVFs that have multiple statements like this are HORRIBLE from a performance standpoint.
2) the clustered PK on the table will probably induce a lot of overhead for absolutely no...
March 4, 2011 at 6:46 am
there is no need to have information on how to identify memory issues in your case. YOU HAVE MEMORY ISSUES - PERIOD. You simply cannot successfully run 4...
March 3, 2011 at 9:35 am
ERStudio from Embarcadero is your friend when you have complex data models!
March 3, 2011 at 9:32 am
I'm with the BULK INSERT camp when it can be used on the particular file type.
March 2, 2011 at 4:05 pm
sqldba_icon (3/1/2011)
DO you know of any good affordable performance tuning consultants?
Affordable is a VERY relative term. Value can come from being able to do something that others cannot do...
March 2, 2011 at 4:01 pm
Viewing 15 posts - 3,556 through 3,570 (of 5,843 total)