I have heard that before in an article I read somewhere but here is some on what the big deal is.http://www.winnetmag.com/SQLServer/Article/ArticleID/21752/21752.htmlHowever the file is instcat.sql can also be an issue with MDAC updates on the server or the clients. To correct you may actually want to search for all instances of instcat.sql left various installs […]
2004-05-18
Does anyone know whether SQL Server 7.0 works under Windows Server 2003?
2004-03-31
45 reads
I am amazed with how many people here have associated a clustered index with a primary key... That's the way the gui does it by default, but by no means does the clustered index have to be on a primary key. You can still have a primary key that isn't clustered on a table with […]
2003-11-21
The optimal environment is if you have plenty of disks to put the system, tempdb, logs, data and indexes on different physical disk arrays. you could even partition your data on separate disks depending on your database design. the overal best performance for the data and the index disk is RAID10 and for log and […]
2003-07-24
The proc does have transaction in it, but I'm printing a message before the first "BEGIN TRAN" statement. Speaking of checkpoints....does anyone know of a DBCC command to force one to occur? I was curious if you can force a database using the Simple recovery model to clean up its transaction log on demmand.
2003-07-23
1 reads
Server 1 DB pubs is logshipped to server 2 db pub. Seperately, Server 1 db pubs replicates to server 2 db pubreadonly. Double the storage requirement but get the most out of your CPU and memory. Log shipping is for disaster recovery not for giving your users a database to run reports off of. John […]
2003-07-17
Hi Dale, quote: Check this out. I found this on Citeseer. Used that site a lot for my Masters: thanks again! Seems to be a good site. Now I only need a good pocket dictionary Cheers, Frank
2003-07-15
1 reads
You might try bol (bools online) for the topics "sp_executesql" and "Using sp_executesql". The object (e.g., table) names need to be fully qualified in order for SQL Server to reuse a cached execution plan. Also, the execution of the query is very much like (maybe it's the same except for permissions) as calling a nested […]
2003-07-11
1 reads
2003-07-10
1 reads
Just one result set? Sure. Create temporary table cursor insert into temptable exec sp_executesql @selSQL deallocate cursor select * from temp table (Hope that's not too sketchy) Guarddata-
2003-07-10
By Rob Sewell
Whether you’re a developer at an agency or an aspiring creator, you can trust...
“Could you help me, we deleted the database’s transaction log file and now that...
I had a couple of clients who were moving content from development catalogs to...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers