I am using this query to find top 15 poor queries, modify as per your request and run it before and after index creation and see everything going as per...

Nassan (7/30/2013)

---

I don't think there is a job Like Production DBA when it comes to pressure and worries about what may happen next minutes on your watch.

I hopeful, there has...

In source server? what will it do to increase it?

Depends on new index size and DB will grow

User DB will never return it to OS automatically and tempdb will not return it till the next SQL restart.

SORT_IN_TEMPDB you might not have set it so sorting will happen in same DB which might have increased the space growth

then possible sorting is happening on the same DB and possible for DB growth

SORT_IN_TEMPDB is it set or not, i hope the large index sorting keeps it growing.

use the below script to find drive free space and DB free space.

use master

CREATE TABLE #TMPFIXEDDRIVES (

DRIVE CHAR(1),

MBFREE INT)

INSERT INTO #TMPFIXEDDRIVES...

added to above user's comments

you can learn some from books, google, online help etc.

To learn all SQL technologies have to come from your experience, reading SQL form's and problems you...

patientnumber looks unique keep this a primary key and create non clustered index as per requirement.

covering index column will work faster than columns not in any columns.

Janda Nel (7/24/2013)

---

Good day

I want to make a job step,but it must do various commands.The steps is as follows.

1.Copy a file over to another file location

2.Insert a records into a...

jpettigrew (7/25/2013)

---

I cannot see the main backup drive in SQL cluster when attempting to do a restore. The backups for the cluster is stored on this drive. I only see...

Thanks all and may i know how application has related to huge free space, any link or suggestions will be helpful.

rajeshn29.dba (7/20/2013)

---

Hi All

1.In mirroring If I add data file in primary server will it reflect in mirror server or not?

If yes can you pls explain me?

2.In transactional replication if we...

Forgot to mention please post new questions in different thread .