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
Parallel
Execute T-SQL Scripts in Parallel
Transact-SQL does not have a simple method to launch multiple parallel running scripts. This tool will change the game. It requires SQL Server 2005 or above.
2013-08-13 (first published: 2009-08-28)
15,784 reads
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
RE: Launcing DTS packages from Stored Procedures
Dean, Access will run the SP, but for some reason it will not update the DTSRUN string in the SP. It's wierd, I can type in the changes and it will prompt me to save, but it never saves. Thanks, fryere
2003-07-10
RE: SQL Server Considerations
quote: Can I host all the SQL Servers on one powerful machine under windows 2000? Yes but consider the traffic going to and from the server. I've found that the problem isn't the machine its the pipeline into the machine. This is a particular problem if you have some analysis software that sends complex requests […]
2003-07-10
RE: SSWUG and PASS
Guess what, I've found a comparison on both groups http://www.sswug.org/comparison.asp posted by swynk some time ago to another list. Just in case you are interested Cheers, Frank
2003-06-26
RE: SSWUG and PASS
I spend more time on this web site then SSWUG. The two sites serve different purposes so I do both. As to PASS vs. TechEd I think PASS every year and TechEd every other year works for me. I am more production focused then I am a developer. Spend more time supporting developers then coding...my […]
2003-06-25
RE: Too many messages on opening and closing data file
I unchecked 'auto close' option on the database property, it is SQL 7, but it is still showing me a lot messages on opening and closing the database files. Do I need to restart the service?
2003-06-25
2 reads
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