thank you for these precisions (and for the french saying)(i'm afraid I'm the system administrator and my own primary support provider too on this one...)i had some weird message yesterday saying "can't scan with (NOLOCK) due to movement data" during an sql operation (nothing phenomenal, something like deletion of 100 records, and insertion of roughly the […]
2004-11-17
HI.I have a database backup(.bak) and I want to know is it possible to restore from that backup just a few database tables? I've looked at the restore database option and I don't see where you can pick out certain tables, only the entire database. I know I can physically make a copy of these […]
2004-11-01
1 reads
If you can add one more column to your table than: create table FIFO(xxx,xxx,xxx, GUID uniqueidentifier) declare @GUID uniqueidentifier set @GUID = NewID() INSERT INTO FIFO ( xxx,xxx,xxx,xxx, GUID  VALUES( xxx,xxx,xxx,xxx, @GUID  // Insert recordSELECT UID AS Value FROM FIFOwhere GUID = @GUID // Get the UID of the record just inserted It works much faster than using temporary table, especially if […]
2004-08-30
Don't use the wizard. It's a piece of #@$%#%$# http://qa.sqlservercentral.com/columnists/ckempster/deattachandreattachdatabases.asp http://qa.sqlservercentral.com/columnists/rsharma/copydatabase.asp Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-19
We have been investigating setting up an active/active cluster. We have identified that cross database chaining is not intended to work across two separate servers. This may be an issue, depending on how tightly security is locked down on the database. We are going for execute permissions only on stored procedures and this policy must […]
2003-06-17
Serious though, looking for a solution. Google. There are plenty people who have had the same problem you have. This is how I found SQLServerCentral. A guy started working here who had never heard of google. He asked was it good. To demo it, I searched on "How do I wipe my @55" I, yes […]
2003-06-11
By Steve Jones
mottleheaded – adj. feeling uneasy when socializing with odd combinations of friend and family,...
By Rob Sewell
In the WordPress community, badges aren’t just for scouts.
By James Serra
The new data governance features in Microsoft Purview are now being made generally available...
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