saravanakumar.G (8/28/2013)

---

Hi,

I have tried and created one sp which will get the table name as input and will return all the records in that table. I will map this...

http://www.apexsql.com/sql_tools_log.aspx

ApexSQL Log

Order now from $1,499 :w00t:

This code will kill all processes who do not have an active request, who's last request was more than 24 hours ago and are connecting from management studio. You can...

My general rule of thumb is:

It's OK to use loops for...

kapil_kk (8/21/2013)

---

Adding some more points to the problem:

inspite of defining columns as SPARSE it is still taking space in database as I read on some blog that if we specify...

avdhut.k (8/16/2013)

---

Hi,

I am trying to import sample data into excel,using following code,but it gives me following error,

Create Table Test

(

a Varchar(2),

b Varchar(2)

)

Insert Into test

values...

http://support.microsoft.com/kb/928518

:doze:

Profiler is a GUI interface to trace, which does put an extra load on the server. Run the trace server side instead.

There is a stairway series on server side traces...

peterswe (8/12/2013)

---

I found out that this statement

select *

from Job_Queue

where JobQueueID not in

(SELECT JobQueueID

from Payment

where JobQueueID is not null)

will...

And when your colleagues get short paid because you thought it essential to put...

I agree. Sending mails and performing maintenance on a list of database objects are the two areas I use cursors in.

5) NOLOCK. This hint is very dangerous. Do you understand all the ramifications of this hint? Is duplicate and/or missing information acceptable? Given that some of these queries are hitting...

I suspect the index used by the optimizer is smaller, rather than narrower.

SELECT

i.name,

SUM(ips.page_count) AS page_count,

MAX(ips.index_depth) AS index_depth

FROM

sys.dm_db_index_physical_stats(DB_ID(), OBJECT_ID('BusinessProcesses'), NULL, NULL, 'DETAILED') ips

INNER JOIN

sys.indexes i

ON ips.object_id = i.object_id

AND ips.index_id = i.index_id

GROUP...

Sean Pearce (7/22/2013)

---

The only issue I have is typing...