Part 1: The Database Administrator's Primary Responsibility
SQL Server Essentials Part 1: A look at the key responsibility of a DBA and why it is so vital.
2011-06-10 (first published: 2009-09-14)
24,046 reads
Becoming A DBA
RE: How to insert/update using openquery
i have tried the example refered to me by allen. begin tran SET QUOTED_IDENTIFIER OFF SET XACT_ABORT ON declare @cmd varchar(2500) Select @cmd = 'Update openquery(LEAVESBOX,''Select SNER,SNBHNO,SNEN,SNLC,SNASDT,SNAEDT,SNUPD From LVSNP'') Set SNUPD = 123456 Where SNER = ''080'' And SNBHNO = ''200305000004'' And SNEN = ''000021504'' And SNLC = ''SLECC'' And SNASDT = 11022003 And SNAEDT […]
2003-08-07
3 reads
RE: Does Your SP Choke on Errors
quote: Generally, most things can be trapped but the more error trapping is done at the SQL end the bigger the performance hit. If there are going to be multiple apps hitting a database then I put more error trapping in the database and middle tier. If there are very few apps then I expect […]
2003-06-26
RE: Best practice when to use an index
Frank, quote: Now when the fill factor is less than 100% you might be wasting space, when it is 100% you're in risk of getting fragmented indexes which would affect performance. You will only get fragmentation if the indexed column is updated, or (I suppose) if you get page splitting/a record moving in the data […]
2003-06-25
Blogs
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...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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