I frankly wouldn't advice doing it using the model database:-

The model database is a template for all future databases. Do not change it unless you want the change in all...

http://www.sqlservercentral.com/Forums/Topic432976-360-1.aspx

Try going thru this

Msg 651, Level 16, State 1, Line 4

Cannot use the PAGE granularity hint on the table "dbo.datachurn" because locking at the specified granularity is inhibited.

Hmm interesting , I got the...

to each his own 😀 . I had always used a config file to store all my variables and connections strings. But recently I have shifted to using the registry...

Check if u have enabled AWE. Have your tried running perfmon? what are the results?

If you can provide details ( specific numbers ) it will be more helpful

are u using 64 bit or 32 bit , check sql server properties, other than the migration to virtual server have you changed anything else.

one approach would be to store the connection string as an entry in the registry so that all new packages can also use them. you can also share a single...

Touche 😀 , i did automatically go the SSMS to try it out before I realized I Uninstalled SQL Server in my laptop yesterday.

Ill try it out as soon as...

Personal experience says just create a dedicated script for LIVE and perform the deployment.

The reason...

Interrogating the server list , or dynamic sql etc are by nature subject to change. A...

are the ids identity columns , u cud try DBCC CHECKIDENT

@Gail , what if we use a lock hint ?

If this is for your own purposes I would suggest you wait till the RTM is out for SQL 2012.

If you are asking for a project your working on...

The fact that adding additional processors increased the query execution speed suggested that the query needs to be re written . I don't think the execution of one single procedure...

To the first...

Hi Satish

Everyone who are replied to this thread have been in SQL for years now. Most are legends in SQL and the rest are getting there. The one thing they...