Hi Dave, At my previous company we had a datawarehouse of about 1.4TB...the biggest db was about 1.2TB We used Red-Gate's SQL Backup with great...
Hi, The pattern will remain the same.
Best way to check is in the DTS package logs (assuming the packages are set up to be logged):select convert(decimal(18,2),s.elapsedtime/60.00) as...
Check the column delimiters for each column under the "Advanced" tab, and ensure that only the last column's delimiter is {CR}{LF} and all the rest...
The posted code above will do exactly that. As Adriaan mentioned there will definitely be a performance impact, and you might have to consider...
Yes, it is definitely possible. You can add a case to your where-clause: select ... from ... where case @DateType when 1 then DateType1 when 2...
We currently do a restore of the full production database in test/dev because we have enough space. It would be interesting to know how the other...
The last time we performed a native SQL backup (the database was about 800GB) it took more than 12 hours. Our first backup with the Red-Gate tool on...
Hi Dave, I cannot comment on everything, but with regards to 3rd-party tools my opinion is that you should definitely look into getting one. We are...
This error usually occurs when you try and connect to a server with a domain account, but the server is setup to only use sql authentication...or the...
I think unless that table will be used to join a very large table on one of the 18 columns only, and that column is not already in the clustered...
I think that the answer to your question will be closely related to the environment. If you have plenty of memory and fast disks, then scanning a...
Although probably not impossible to do in a stored proc, I would suggest that you do this with the script component in SSIS. All filesystem...
cool man, no problem.
If you have separate insert statements for every record, then there is no downside to letting the database handle it. Using a UNION will not achieve...
Unless I am mistaken, the whole insert statement will be rolled back if one row fails based on a constraint...meaning that no rows will be inserted...
I would go for a left outer join, unless every single product will have a corresponding entry in the ProductQualification table [:)] SELECT...
Hi, To answer your questions: 1) I don't think there will be any reason not to index col2/3/4...unless you want to scan the whole table everytime the...
I've checked the execution plans of both those queries, and both result in a Hash Match/Inner Join being performed. Are you sure this what caused the...
Sorry...my bad...the url should be http://localhost/reportserver$production2005 and not what I posted earlier. The instance name (plus the leading $)...
Separate names with a comma.
