10 SQL Snippets For Faster, More Effective Code
How many hours per week do you spend writing the same SQL again and again?
2015-07-16
7,973 reads
team
Insensitivity: A Good Technique?
This article explores the place of emotion among knowledge workers doing team-based design activities.
2013-04-05
164 reads
RE: Cannot Register an Instance of SQL Server 2000
Hi rmizzar!It might be caused by what protocols that are used. I would try to first set the language to tcp/ip and if that does not work, to named pipes.If you are logged in on the server when you do this, use the Client Network Utility and go to Aliases tab. Type in the servername […]
2004-07-28
Corrupted cluster index on a replicated table.
Corrupted cluster index on a replicated table. I can fix the problem - I/O error (bad page ID) detected during read at offset. DBCC checkdb shows a corruption on an index. Normally I would drop/recreate the index or run checkdb with a repair_rebuild, but this table is replicated. What steps are needed to fix the […]
2004-01-29
2 reads
Tigger on inserts
I have applied a trigger on inserts of a table. The triger might execute for 10 or more seconds depending upon the data in the table. The trigger might affect other tables as well. When a record is inserted into the table, the triger fires and starts executing. Now suppose that as soon as the […]
2004-01-29
Blogs
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
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