Add Dependencies to a SQL Server Resource in Windows 2003
In this article, see how to add a dependency to a SQL Server Resource in a Windows 2003 cluster.
2015-11-10
861 reads
Windows 2003
How to Add a Drive as a Clustered Physical Disk Resource in Windows
This article is covers how to add a drive as a Clustered Physical Disk Resource in Windows 2003.
2015-11-09
5,541 reads
Can you set a pagefile more than 4GB?
Can you set a pagefile on a Windows machine to more than 4GB? Stanley Chan shows us how after an issue with a crashed Windows machine.
2010-08-18
8,255 reads
Administrator Password Got Change!
I know that I should not post this question in this group, but just take a chance for fortune since we have a lot of experts in this group. I had a serious problem. Someone had changed our domain admin password. Is there a way to figure out who changed it, or by any event […]
2004-08-12
RE: deduping data in a flat file
If you have room for two copies of the data, I think this might run faster than the self-join and DELETE method.First import the data into a staging table.Then create another staging table with the same structure, and put a unique constraint on the dedupe fields using WITH IGNORE_DUP_KEY. SELECT * INTO StageUnique FROM Staging […]
2004-08-12
RE: When to DTS Object Model??
I use the designer up front and stick with that if I can. It takes a lot of code to do what the designer does. Even if you need to embed in VB, use the designer as a code generator. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-07-21
RE: what is the best way to search between tow date fd
Look at the code I posted; it explains how to add (or subtract) hours from GETDATE()...using DATEADD(hour, n, GETDATE())
2003-07-14
Blogs
Enabling an Index: #SQLNewBlogger
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
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