Two suggestions, first one is counting by subtracting the length of the string after removing all the X characters to the original length of the string, the second one is...

Grant Fritchey (4/11/2015)

---

Since no one else pointed it out, I sure will:

WHERE (dbo.CLI.CLITYPE LIKE '%A%') AND (dbo.SVAC.PROGNO LIKE '%286%' OR

dbo.SVAC.PROGNO LIKE '%288%' OR

dbo.SVAC.PROGNO LIKE '%289%')

That is going to lead...

Jeff Moden (4/11/2015)

---

robertharrison (3/25/2015)

---

The following was found as a solution to detecting non-printable characters in a string. I can find no explanation of how the COLLATE function is used.

Can...

sql-lover (4/11/2015)

---

Eirikur Eiriksson (4/11/2015)

---

sql-lover (4/11/2015)

---

Grant Fritchey (4/11/2015)

---

As far as I know, if you have to have a guaranteed, 100% accurate, count of the rows in the table, the way to...

MotivateMan1394 (4/10/2015)

---

Hi

We should monitor Database Objects created by development dept.

in 2 views :

- View , sps , .....

sql-lover (4/11/2015)

---

Grant Fritchey (4/11/2015)

---

As far as I know, if you have to have a guaranteed, 100% accurate, count of the rows in the table, the way to do it is...

Does anyone have an idea on how to solve this problem?

😎

Quick thought, it is going to be somewhat tricky to correlate the actual tempdb I/O to an execution, here is an example alternative that checks for # or tempdb in...

Quick suggestion with a CTE and ROW_NUMBER ordered by the length of the prefix

😎

USE tempdb;

GO

SET NOCOUNT ON;

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

CREATE TABLE dbo.TBL_PREFIX

(

PREFIX_VALUE...

Quick thought, let's not forget that tables can have more than one partition

😎

SELECT

OBJECT_NAME(SP.object_id) AS TABLE_NAME

,OBJECT_SCHEMA_NAME(SP.object_id)...

Quick suggestion, use openrowset bulk

😎

USE tempdb;

GO

SET NOCOUNT ON;

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

CREATE TABLE dbo.TBL_SCRIPTFILE

(

SF_ID ...

corrosion

Refactoring

SQLRNNR (4/10/2015)

---

Luis Cazares (4/10/2015)

---

SQLRNNR (4/10/2015)

---

Luis Cazares (4/10/2015)

---

Someone just mentioned that you could have 2 clustered indexes on a table. But I'm sure he's high. 😀

http://www.sqlservercentral.com/Forums/FindPost1676220.aspx

But, think about it, what if...

sql-lover (4/10/2015)

---

Thanks for the responses so far.

I need 100% certainty. The DMV/count is needed to identify the table(s) with an empty set. A massive DDL change will be deployed against...