I just did this type of research recently to validate some storage that was recently presented to one of my servers. IIRC Server 2008 uses an offset of 1024KB as...

Lynn Pettis (6/1/2012)

---

opc.three (6/1/2012)

---

Lynn Pettis (6/1/2012)

---

opc.three (6/1/2012)

---

Lynn Pettis (6/1/2012)

---

opc.three (6/1/2012)

---

Nothing against VB.net (I used to develop lots of VB6 and learned VB.net before I learned C#) but C# has earned...

Lynn Pettis (6/1/2012)

---

opc.three (6/1/2012)

---

Lynn Pettis (6/1/2012)

---

opc.three (6/1/2012)

---

Nothing against VB.net (I used to develop lots of VB6 and learned VB.net before I learned C#) but C# has earned a dominant position...

Lynn Pettis (6/1/2012)

---

opc.three (6/1/2012)

---

Nothing against VB.net (I used to develop lots of VB6 and learned VB.net before I learned C#) but C# has earned a dominant position in terms of...

pveilleux (5/31/2012)

---

Hello, all,

In digging around on one of our servers, I found what appears to be someone logging in as the SQL Server/Agent service account and running jobs. I'm...

Nothing against VB.net (I used to develop lots of VB6 and learned VB.net before I learned C#) but C# has earned a dominant position in terms of the amount of...

GilaMonster (6/1/2012)

---

I suggest reading the entire book (not because I worked on it, it's just a good book...

Well i guess in this case it wont matter coz the entire Db can be hosted in memory. I wonder if it would be easier to simply use an in...

Never had this issue so just brainstorming here. You could redirect failed rows to an error file, error in that they failed to load due to the network error not...

Why would one want to re-invent the wheel? Database Mail is built atop Service Broker.

Jayanth_Kurup (6/1/2012)

---

You cud monitor the counters for buffer cache hit ratio and page life expectancy , also you should keep and eye on your recompiles and complies per sec ....

Loops internally but no cursor:

DECLARE @sql NVARCHAR(MAX) = N'';

DECLARE @priority VARCHAR(20)= '1=Critical';

SELECT @sql = @sql + 'EXEC msdb.dbo.sp_send_dbmail

@profile_name = ''db mail'',

...

No way around it. Nice post but you asked for an ocean of information. Buying a tablet last year increased my casual and technical reading bandwidth tenfold.

Chapter 4 > Troubleshooting SQL Server: A Guide for the Accidental DBA[/url]

This article explains very clearly why to avoid the pattern:

Multiple Execution Paths[/url]

My opinion: split to separate, more granular procs targeted to one specific purpose each. If the article is too...