Not sure if this helps or not, but I just found a situation on my system (sql 2000) where dbcc dbreindex was not working to clean up extent...
I came across a weird situation that others may or may not have already done for a long time and may say "well obviously" but I figured I would share...
As folks are contributing to the thread I figured I might as well follow up. We ended up going with the EMC CX3-20. A couple of the selling points to...
I'm a bit confused by subsequent questions whether you need to do this for many tables, or just 1 table within the source database. If you are...
Does anyone have any strong opinions regarding an EMC CX3-20 vs NetApp FAS270 SAN solution? Does anyone have any strong opinions regarding the...
For what you are doing you can also consider using the CASE command to do a single pass through the table where you just sum up the individual values...
Or create a 1 row table with a column for each global variable that you need. You can create an index on each column if you want to. Hope it helps,...
The other difference is shear speed. If you only need Column1, Column2 in the results and have say Column3 in the WHERE clause, the system would be...
I'm confused on your question and subsequent answer. In your question you asked quote:Do you think moving all of the tempdb work to a new separate db...
Frank/Dave are certainly right in your second query you are asking for a field from table 2 not in the index which I'd bet is changing the execution...
1. I assume that you are really trying to pull more columns in your select from tbl1 than just the col0 that show. 2. Have you tried using a join...
Thank you for the suggestion. It should help clarify. The IN would let me find an appointment time where Room1 or Room2 are available. I need to find...
I have an appointment scheduling system (I've sort of inherited) that has columns for a typical scheduler where there are time slots and the resource...
Ignoring the variableness of the column lists you have the following will do what you are looking for for the 3 columns you gave as an example (and...
Dan, Glad it helped you. The permanent table is just in case you wanted to run the command daily and retain the data on an ongoing basis so that you...
Your example data for expected results is puzzling to me. I assumed that you wanted to ensure that you had a common number of columns regardless of...
If you have multiple drives/drive arrays available you should be sure to split your have 4 distinct data locations: Data, Indexes, LogFile and...
I simply add a job task which runs sp_cycle_errorlog to my nightly backup job. So that it resets the error/information log every night. I think every...
The sp_helpdb stored procedure internally uses the the #spdebdesc table with the following definition: create table #spdbdesc ( dbname sysname,...
I wanted to follow up on this just to have a record of it: The following command will create a table that will contain the information : create...
Separate names with a comma.
