Why not use the system dmvs? e.g.

SELECT TOP 100 [Average IO] = (total_logical_reads + total_logical_writes) / qs.execution_count,

[Total IO] = (total_logical_reads + total_logical_writes), [Execution count] = qs.execution_count,

[Individual Query] =...

Could you do something like this?

IF object_id('s_sumar_s') IS NOT NULL

BEGIN

DROP TABLE s_sumar_s;

END;

CREATE TABLE s_sumar_s (

ID INT IDENTITY(1,1) NOT NULL,

faux_number VARCHAR(116) CONSTRAINT CK_faux_number CHECK (RIGHT('00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000'+faux_number,116) LIKE...

Because nolock is not "go faster stripes" ? More seriously, probably because the nolock hint is performing a scan which needs to read more pages due to reading in...

You can fix the syntax like this: -

DECLARE @Dept AS INT

SET @Dept = 40

SELECT *

FROM plu_file_dates

WHERE pluid IN (SELECT pluid

...

In one sproc, maybe make use of Scope_identity()?

It'll potentially take some time: -

UPDATE yourTable

SET yourColumn = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(

...

Sorry you feel that my reply was rude, it certainly wasn't intended to be. Terminology is often difficult on an international forum, something I try to take account of when...

Sample data: -

IF object_id('tempdb..#testEnvironment') IS NOT NULL

BEGIN

DROP TABLE #testEnvironment;

END;

SELECT ID, Name

INTO #testEnvironment

FROM (VALUES(1, 'Fred'),(2, 'Joe'),(3, 'Bob'))a(ID, Name);

Query: -

DECLARE @Delimitedlist VARCHAR(8000) = '1,3,2';

SELECT STUFF((SELECT ','+a.Name

...

This is not all that tricky, so rather than spoon feed you the answer I'm going to try and help you to arrive there on your own.

Firstly, it's always a...

JblakTSql (2/13/2013)

---

So I have this odd issue that I can't figure out how to solve. I have a poorly written view which runs slowly but works (returns data in...

IF object_id('tempdb..#testEnvironment') IS NOT NULL

BEGIN

DROP TABLE #testEnvironment;

END;

SELECT CAST(dtDate AS DATETIME) AS dtDate, sDocIdPrefix, CNT

INTO #testEnvironment

FROM (SELECT '2013-02-11', 653, 3683 UNION ALL

...

So, the SQL Bits agenda has been released, anyone going? I'm planning on grabbing a Friday ticket tomorrow morning, but unsure about the Saturday.

anthony.green (2/13/2013)

---

As your dates are in DMY format, you need to ensure that the connection is set to use dates in DMY format or put an implicit change in the...

Random guess: -

USE [IdealOffice_NSI_Live]

GO

DECLARE @RollNumber INT, @PDADate NVARCHAR(50), @Requiredby NVARCHAR(50), @UpdateDate1 DATETIME, @UpdateDate2 DATETIME,

@VisitDate NVARCHAR(10), @BookedDate NVARCHAR(30), @StatusUpdateDate NVARCHAR(30), @NewRefNum NVARCHAR(5), @OriginalRefNum NVARCHAR(5),

@ID UNIQUEIDENTIFIER, @status UNIQUEIDENTIFIER, @InspectorID SMALLINT,...

What does the original data look like? What is the DDL for the table?