Review : Rent A Geek Book with IQReference
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/bknight/iqreference.asp
2001-08-26
4 reads
administration
Sending SP output to a text file
We have SQL Servers: 6.5/7/2000. How can I issue, via SQLServereAgent scheduler, the commands "sp_helpdb, sp_helplogins, sp_helpdevice" and send the output to a textfile? TIA, Bill Salkin
2001-08-24
41 reads
Failed Updates to Linked Tables
I know Access isn't the best front end program for SQL Server but it's what I had to use. Anyways, I'm new to the SQL Server world and am both developer and administrator of a database. I have linked my tables into an Access front end, but every once in awhile I get an error […]
2001-08-24
2 reads
Hot Transact SQL Programmer wanted - London SE1
We are a long established (1980) travel company with a turnover in excess of £140 million. We require an additional expert transact SQL programmer to add to our team. If you have what it takes to work on a state of the art development consisting of over 500,000 lines of transact SQL code, manipulating 1500 […]
2001-08-24
8 reads
Dynamic TSQL in trigger using values from inserted
How to build dynamic TSQL statement in an instead of trigger for inserting values from inserted to base table? A view with instead of trigger is great tool for security. But there are some problems. For example if the instead of trigger defined on a view inserts all columns to base table, the base table […]
2001-08-24
1 reads
Introducing IQReference
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/sjones/iqreference.asp
2001-08-24
3 reads
2001-08-23
151 reads
profiler - "duration" column
Hi all After some testing, I have found that the "duration" filter/column is a poor one to measure DML performance. The trace seems to pick up the duration for the entire elasped time for not on the DML to run, but its parse time, and connect/disconnect time for the transaction returning back to the end-user. […]
2001-08-23
34 reads
Soon upgrading to SQL SP 3. Gotchas?
Yes, Are there any known "gotchas" to look out for when applying SQL SP3 in an NT 4 environent? Logins, Backup, DTS package, gotchas? (Some SQL boxes has SQL 7 SP1, others have no SQL Service Pack at all) Bill Salkin
2001-08-23
2 reads
EM 2000 Client utilites won't install
A developer told me he had installed a SQL 2000 Beta version of EM on his box. He now wants to install the real mccoy. I insert the SQL 2000 Standard CD. We get to the "Computer Name...Local Copy" screen. Pressing next gives the error message: A previous program installation created pending file operations on […]
2001-08-22
3 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
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