Viewing 15 posts - 421 through 435 (of 1,131 total)
NOLOCK is the same as READUNCOMMITTED:
From BOL:
Specifies that dirty reads are allowed. No shared locks are issued to prevent other transactions from modifying data read by the current transaction, and...
SQL = Scarcely Qualifies as a Language
June 17, 2008 at 11:45 am
Here is some SQL to get all of the database properties and has been tested with both 2000 and 2005 with various collatations. The SQL is different for SQL...
SQL = Scarcely Qualifies as a Language
June 17, 2008 at 11:33 am
Promotional activities are those that advance software thru the various phases such as usability testing, functionallity testing, performance testing and finally to productions.
For the US, the Sarbanes-Oxley Act titled...
SQL = Scarcely Qualifies as a Language
June 16, 2008 at 11:25 am
As I used live production data and sp_spaceused reports about one and half million rows and 256Mb of space used, posting that much data is not possible.
SQL = Scarcely Qualifies as a Language
June 16, 2008 at 9:51 am
I have sent Paul Nielsen an email letting him know about the WareZ site.
SQL = Scarcely Qualifies as a Language
June 14, 2008 at 7:41 am
This message is related to the network.
Check the NIC setting on both servers and insure that "link speed & autodetect" is NOT "auto-detect" and that the other parameters are...
SQL = Scarcely Qualifies as a Language
June 14, 2008 at 7:22 am
This SQL should work from the master database:
alter database carl_test
set offline with rollback immediate
restore database carl_test
from disk = 'r:\carl_test.bak'
with replace
SQL = Scarcely Qualifies as a Language
June 12, 2008 at 2:39 pm
See http://support.microsoft.com/kb/307487#6 for why you should not shrink tempdb while in-use:
Effects of Execution of DBCC SHRINKDATABASE or DBCCSHRINKFILE While Tempdb Is In Use
If tempdb is in use and you attempt...
SQL = Scarcely Qualifies as a Language
June 12, 2008 at 2:30 pm
Just to add a practical reason why the data model is poor, trying adding a uniqueness constraint on Product.book_isbn. Since the value will be null for all of...
SQL = Scarcely Qualifies as a Language
June 12, 2008 at 11:48 am
PAGELATCH_EX indicated waits for physical I/O
CXPACKET indicates waits for parallel processes to complete.
NETWORKIO indicates waits for Network I/O
For NETWORKIO, use perfmon to determine the workload and if there is sufficient...
SQL = Scarcely Qualifies as a Language
June 12, 2008 at 11:33 am
Please read "Why should I consider using an auxiliary calendar table?" at
SQL = Scarcely Qualifies as a Language
June 11, 2008 at 1:47 pm
Regarding you question "When creating databases to use 'sa' or N'Domain\Administrator' user credentials or a separate [dbo] sql account?"
My answer is none of the above.
Security best practices dictate that logins...
SQL = Scarcely Qualifies as a Language
June 11, 2008 at 11:59 am
Under SQL Server 2000, space usage is not maintained in real time and you must run "dbcc updateusage" with appropriate parameter values to get the correct information.
SQL = Scarcely Qualifies as a Language
June 10, 2008 at 1:07 pm
For a Temporal Project, where the project includes all of the primary key columns, benchmarks of three SQL Server solutions were performed and documented below. The three different solutions were...
SQL = Scarcely Qualifies as a Language
June 10, 2008 at 12:45 pm
Hardware or driver errors often will have these events in the system event log:
The Driver was unable to obtain the HBA slot number for ScsiPort 3. No extended information in...
SQL = Scarcely Qualifies as a Language
June 10, 2008 at 8:03 am
Viewing 15 posts - 421 through 435 (of 1,131 total)