Viewing 15 posts - 301 through 315 (of 608 total)
saravanakumar.G (8/28/2013)
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...
September 2, 2013 at 7:30 am
August 29, 2013 at 5:51 am
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...
August 28, 2013 at 6:44 am
techmarimuthu (8/26/2013)
I have some doubts in using of loops in sql server 2005can you please anyone help me?
Thanks in advance
My general rule of thumb is:
It's OK to use loops for...
August 28, 2013 at 5:43 am
kapil_kk (8/21/2013)
inspite of defining columns as SPARSE it is still taking space in database as I read on some blog that if we specify...
August 21, 2013 at 7:44 am
avdhut.k (8/16/2013)
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...
August 19, 2013 at 6:39 am
August 19, 2013 at 6:14 am
Alan.B (8/13/2013)
Stupid Microsoft :crazy:
:doze:
August 13, 2013 at 8:08 am
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...
August 13, 2013 at 8:05 am
peterswe (8/12/2013)
select *
from Job_Queue
where JobQueueID not in
(SELECT JobQueueID
from Payment
where JobQueueID is not null)
will...
August 12, 2013 at 6:02 am
kevin_nikolai (8/2/2013)
SELECTfirstname
,salary
FROM dbo.employee e WITH (nolock)
JOIN salary s WITH (nolock)
ON s.employeeid = s.employeeid;
And when your colleagues get short paid because you thought it essential to put...
August 12, 2013 at 5:32 am
ScottPletcher (7/22/2013)
This is why cursors exist.
I agree. Sending mails and performing maintenance on a list of database objects are the two areas I use cursors in.
July 24, 2013 at 3:55 am
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...
July 24, 2013 at 3:40 am
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...
July 24, 2013 at 3:36 am
Sean Pearce (7/22/2013)
octavuslimited (7/19/2013)
I'd be interested to know whether people think this is useful and what issues (licensing, security, traffic etc.) there might be.
The only issue I have is typing...
July 22, 2013 at 11:02 am
Viewing 15 posts - 301 through 315 (of 608 total)