The default value of 5 is very low, normally recommend starting with 50 and work from there.

😎

Here is one way of searching all character type columns in all tables, be careful though as this can be quite hefty for large databases.

😎

USE TEEST;

GO

-- THE PATTERN TO SEARCH...

Another option is to shred and reconstruct the xml, here is a quick example with some test data

😎

USE TEEST;

GO

SET NOCOUNT ON;

--/*

-- SAMPLE DATA SET

IF OBJECT_ID(N'dbo.TBL_PRODUCT005') IS NOT NULL DROP TABLE...

info.sqldbamail (5/2/2016)

---

Hello Everyone,

We have a server configured with 24 core processor with 0(Zero) MAXDOP, and queries are running with parallelism can any one suggest to set this configuration,

1) How to...

sqlnewbie17 (5/2/2016)

---

How to get only version number from

select @@version

Result should be 2000/2005/2008/2012... only

and not the entire string as here:

Microsoft SQL Server 2008 R2 (SP3) - 10.50.6000.34 (X64)

Aug 19 2014...

You might find this post helpful[/url]

😎

Can you post the execution plans for both queries? When updating the statistics did you use full scan, sample or resample? Are the maxdops the same on both?

😎

Luis Cazares (4/29/2016)

---

Something like this?

SELECT DISTINCT

CASE WHEN MAX(Criteria) OVER( PARTITION BY ServiceName) <> MIN(Criteria) OVER( PARTITION BY ServiceName)

...

errare humanum est.

😎

Homo...

Out of curiosity, how many jobs do you have?

😎

The error message states that the table/view "TimCIS.dbo.Legis_Districts.Zip4" cannot be found, check the actual database and object names and make certain you can run queries like

SELECT COUNT(*)

FROM TimCIS.dbo.Legis_Districts.Zip4;

😎

Quick question, do you have a database called TimCIS?

😎

Lowell's code in a slightly different flavour

😎

DECLARE @DROP_JOP_TEMPLATE NVARCHAR(MAX) = '

-- {{@JOB_NAME}}

IF EXISTS (SELECT job_id FROM msdb.dbo.sysjobs_view WHERE name = N''{{@JOB_NAME}}'')

EXEC msdb.dbo.sp_delete_job @job_name=N''{{@JOB_NAME}}'', @delete_unused_schedule=1;

';

SELECT

REPLACE(@DROP_JOP_TEMPLATE ,N'{{@JOB_NAME}}',MSSJV.name)...

Quick thought, you can pass null as job_id and the job name, sp_delete_job uses sp_verify_job_identifiers to find the job_id if it isn't passed to the proc. Behind the scene it...

BLOB_EATER (4/29/2016)

---

GilaMonster (4/29/2016)

---

GilaMonster (4/27/2016)

---

BLOB_EATER (4/27/2016)

---

GilaMonster (4/26/2016)

---

BLOB_EATER (4/26/2016)

---

GilaMonster (4/26/2016)

---

SQLRNNR (4/26/2016)

---

The sith lord is Supreme Leader Snoke and suspected to be Darth Plagueis (the one that can create life from death according...