Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017.
2018-06-04 (first published: 2008-02-23)
47,274 reads
go ahead and download the service pack from this page; http://www.microsoft.com/sql/downloads/2000/sp4.mspxnote in the middle of the article it explicitly says that it is for the MSDE, and that you need to know the instance name:Microsoft SQL Server 2000 Desktop Engine and SP4Users who have an existing instance of MSDE 2000 must know how their instance of […]
2005-05-28
No, you will need to add EXEC rights for procedures explicitly.
2005-05-09
Hi all,I am using SQL Server 2005 CTP which has Adventureworks as sample database. I need to generate a script for the database (structure and data) so that I can save it in a .sql file and generate it whenever I need to. I basically need it for my testing, where I need to create or drop the database n number of times.The Script […]
2005-04-29
I think I am sorted with this now anyway.Advice is - Keep transaction very short - Return server to default isolation level READ COMMITTED when on and on error found. - Consider using HOLDLOCK
2005-04-07
I agree with the others, very interesting article and something that I did not know about. However, I am not quite sure that everything is fully correct in the article, or at least I am not sure what conclusions to draw from it. First off, I could not trace any SP:CacheMiss events when only the […]
2005-03-10
2005-02-21
well if the procs work.. nothing. SysDepends is used when ou ask sql server to show the object dependencies (spa needs table1,view2 and vice-verca)... but this is not always accurate. So I guess the worst that could happen is that you delete a proc that is actually needed but that sql server "said" it wasn't.
2005-02-21
2005-02-18
My Linked Server name and sql query change. Even if I write multiple queries to fulfill all the conditions, I am still left with the linked server name as a variable?The latest thing is to use four-part name. Can I supply variables to do that job?We do not want the server locations to be hard […]
2005-02-16
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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