Viewing 15 posts - 48,316 through 48,330 (of 49,571 total)
What more do you want to know on CTEs? Here's a good, albeit fairly technical, article on CTEs.
http://blogs.msdn.com/craigfr/archive/2007/10/18/ctes-common-table-expressions.aspx
October 29, 2007 at 2:39 am
I'll give this a try.
Temp tables
Behave just like normal tables, but are created in the TempDB database. They persist until dropped, or until the connection that created them disappears. They...
October 29, 2007 at 1:09 am
You've got quite a few table scans in that query (Address, Business_Service, Business_Service_Category, Business_Sub_Category). Without the schema I can't offer suggestions, but if those are large tables, you may want...
October 29, 2007 at 12:48 am
SG (10/26/2007)
Could it be a caching issue? Now we aren't using the server so much, nothing is...
October 29, 2007 at 12:25 am
It's not quite clear from what you said. Do you think profiler's showing too many events, or too few?
October 27, 2007 at 6:30 am
What transfers/sec is good depends on the hardware you have. Diffrent disks and disk configs have different max capacities. Maybe someone else will be able give some figures.
Page splits/sec should...
October 26, 2007 at 10:20 am
There's a fairly well-known issue around SQL and hyperthreading. I know it sounds strage, but see if you can get the hyperthreading disabled and see if the ETC improves at...
October 26, 2007 at 10:09 am
Put an order by on your select and your delete, or there's no guarentee that you'll get the same records. Especially since you have a nolock on the select.
Without an...
October 26, 2007 at 8:06 am
Has the amount of data been transfered increased? Has the size of the tables increased?
Is this ETC across networks? If so, is the network handling the load?
October 26, 2007 at 8:04 am
I would run profiler over the time that the ETL process runs. Capture the SQLBatchCompleted event (under T-SQL) and the RPC completed event (under stored procedures)
That will give you a...
October 26, 2007 at 7:18 am
Are the indexes the same between the original and new server? By default, nonclustered indexes are not copied when a table is replicated.
October 26, 2007 at 6:56 am
The problem with writing an article on indexing, is that the 'best' indexes for a table depend on a large number of factors, and th table structure is probably the...
October 26, 2007 at 4:27 am
For the exec plan cache query, run this in the db that has the stored procs you're interested in. DB will need to be in compat mode 90
SELECT creation_time, last_execution_time,...
October 26, 2007 at 1:07 am
If the procedure has been executed recently, it may be in the execution plan cache. If that's the case you can find the time the plan was created and the...
October 26, 2007 at 12:55 am
This works in SQL 2005, but ot in SQL 2000. In 2000, the only ways to do this are dynamic SQL or RowCount
October 26, 2007 at 12:36 am
Viewing 15 posts - 48,316 through 48,330 (of 49,571 total)