sqldba_newbie (10/30/2012)

---

I have gone through many many different forums in trying to identify my tempdb issues. None of the queries are giving me the data i want. Basically at...

sqldba_newbie (10/31/2012)

---

I have a select query which is in a "hung" state. I checked there is no blocking. From the activity monitor i see that Wait type is NULL. I...

jdpaschedag (10/30/2012)

---

I believe if SSRS has been installed/enabled on my server, I can find out be looking in the sys.databses table for one of the two ReportServer% DBs, right?

How can...

balasach82 (10/30/2012)

---

Need a query which gets me the list of jobs which is scheduled to run on a particular day and its scheduled run time. I need the schedule even...

I know this is OLD .. but still someone will stumble upon this and...

Luis Cazares (9/5/2012)

---

It might not be the optimal way, but it's simple enough for everyone to understand. However, I haven't tested for performance against other methods.

DECLARE @test-2Table(

MyStringvarchar(MAX))

INSERT

Luis Cazares (9/4/2012)

---

Can you explain more your requirements?

Because I'm sure that this won't work for you.

SELECT inputString, SUBSTRING( inputString, 1,42) + SUBSTRING( inputString, 105,16)

FROM (SELECT 'BUILTIN\ADMINISTRATORS: [System Admin]YES;[Security Admin];[Server Admin];[setup...

-- deleted double comments --

Somehow it posts twice .. Please delete this one..

Thanks,

Somehow the comments are posted 2 times ... Need some coffee ...

swiedner (8/12/2012)

---

So, let me first preface this by saying, I've been a SQL Server DBA for 13 years. I've performed some hardcore administration over the years for some hardcore clients...

Good article ..

There is a slight potential security risk associated which is described here http://blogs.msdn.com/b/askjay/archive/2011/03/11/why-is-using-instant-file-initialization-on-my-sql-server-a-potential-security-issue.aspx

Some misconceptions are well explained here: http://www.sqlskills.com/BLOGS/PAUL/post/Misconceptions-around-instant-file-initialization.aspx

Shark Energy (3/9/2010)

---

Can anyone help me understand how the 63 hidden sectors and the alignment calculations above come together? I have read the MS White papers but can't get my...

Perfect !

Again, thanks a lot for your help in understanding the concepts 🙂

Thanks a lot Perry !!

Very helpful.

Out of curiosity, is there any way that the relation between the disk# and the drive (e.g c: ,d:) can be found meaning they can...