if user cancels the transaction, then SQL Server will roll the transaction back. A ROLLBACK statement backs out all modifications made in the transaction by returning the data to the state it was in at the start of the transaction. A ROLLBACK also frees resources held by the transaction.Don't simply restart SQL Server, Sometime, SQL Server […]
2004-01-28
1 reads
Wouldn't something like this be more useful?SELECT SUM(Length) FROM syscolumns WHERE OBJECT_NAME(Id) = 'Tablename'
2004-01-13
Hello Dinesh,English Query itself provides a sample or two of how to use VB to interface with English Query. See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/eqbol/eqconcpt_5egi.asp for details.Hope this helps! Chris
2004-01-13
You could also try horizontal partioning and placing the partitions on seperate filegroups which reside on different physical raid volumes. The same can be done with the indexes. Check the following topics in Books online, "Partitioning", "Using Files and Filegroups" and "Data Placement Using Filegroups". Hope this helps Phill Carter -------------------- Colt 45 - the […]
2003-12-02
.Net has the application test center that is pretty worthwhile for testing. Just record a web session, play it back, get lots of charts and graphs. Supports multiple users per test. Honestly takes 5 minutes to get up and running for a simple scenario. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-09-03
2 reads
Check your machine application and system logs. You may have some kind of hardware issues with the RAID disks.
2003-08-04
quote: I woul like to do that, unfortunately, I am behind exchange server and hence cannot post any code here. I will try from my residence. does a simple copy and paste not work ??? Cheers, Frank
2003-08-04
Hello, I woul like to do that, unfortunately, I am behind exchange server and hence cannot post any code here. I will try from my residence. Thanks indeed, Jacobe
2003-08-04
2003-08-04
Andy/jpipes Thanks for your help guys but have FINALLY figured this one out - the problem lay in the select scope identity. Nasty, nasty bug that lay in our code for years undetected: SELECT @out_MessageId = SCOPE_IDENTITY() FROM TableA GO Should be simply: SELECT @out_MessageId = SCOPE_IDENTITY() GO Seems as if the query was processing […]
2003-07-24
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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