2010-07-06
3,074 reads
2010-07-06
3,074 reads
2009-03-19
3,826 reads
2009-03-05
3,673 reads
Table locking hints provide developers much tighter control of their transactions. Look at the benefits and disadvantages of using the NOLOCK and READPAST table hints in SQL Server
2008-07-15
5,492 reads
hi, which of the (2) is faster or better for performace.. #tempTable or @table i have read information on both.. thanks
2005-05-16
We are currently debating how to store BO's within our SQL Server DB.We have a object to relational mapping layer that allows us to map BO's to DB tables. It has been suggested that we take the serialised BO graph and just place it in to a blob within the DB.I'm looking for any pro's and […]
2004-09-09
1 reads
I've been struggling with this one for a while. Guess it's easy when you know how??I am running a query across two views.View A contains People recordsView B contains diary entries for those people records.There are multiple diary entries on View B for each of the View A RecordsI want to run a query giving […]
2004-07-30
I would like to understand how this is working in the first place. Does anyone have a minute to tell me more about how it works.Also I noticed that it will pick up any servers you have registered and will not pick up the 'local' server if it is noted possibly in the registry as such.
2004-05-04
Below is a trigger that I'm TRYING to use (in SQL2000) to list which columns are updated. However, it never stops running and I can't determine why. Apparently the WHILE maybe generating an infinite loop. To test, just change the table name 'admin' in a few places. Any help would be appreciated. ------------------------------------------------------------------ CREATE Trigger tr_admin -- list all […]
2004-04-07
424 reads
I guess I hadn't noticed the Command type drop down box.Once I changed that, it worked like a charm. Thanks!!!Jarret
2004-03-16
By Steve Jones
In a previous post, I set up the basic databases for the PoC project...
By Steve Jones
Today’s coping tip is to plan something fun and invite others to join you....
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...
Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...
Hello everyone. I don't post here often even though I am constantly on the...