Update statistics in parallel
This articles shows a technique that generates and launches an SSIS package to update statistics in parallel.
2013-01-28
5,416 reads
DTSX generate
RE: interesting query
If you're using dynamic SQL, you could substitute CHAR(39) for the single quote, CHAR(91) for the left bracket and CHAR(93) for the right bracket, as follows:------------------------------------------------------ DECLARE @SQL varchar(200)SELECT @SQL = 'SELECT * FROM tab1 WHERE fld1 LIKE ' + CHAR(39) + 'Ph' + CHAR(91) + '(' + 'L' + CHAR(39)EXEC(@SQL) ------------------------------------------------------It will generate the […]
2004-01-16
RE: Database Placement
Personally, I don't like the thought of all DB environments on the same server. The potential of un-wanted access or modification to the production DB is to great. I do not have a great problem with the test DB as much as the development DB. Development is an environment where you not only create objects but may […]
2004-01-16
RE: Well hidden on technet....
Whooppss! Spoke too soon. I did end up finding it. Bet we hear they got hacked! -SQLBill
2004-01-16
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers