First, cluster the tables for best (overall) performance. In particular, don't assume that every table should be clustered by identity. That's most often simply not the best way...

Eric M Russell (9/26/2016)

---

ScottPletcher (9/23/2016)

---

Not necessarily. If the best clustered indexes are not...

Not necessarily. If the best clustered indexes are not already in place, you...

CREATE TABLE #temp1_dup_emails (email varchar(20) PRIMARY KEY);

Insert into #temp1_dup_emails

SELECT CASE WHEN which_email = 1 THEN email1 ELSE email2 END AS email

FROM #temp1

CROSS JOIN (

VALUES(1),(2)

) AS which_email(which_email)

GROUP...

Personally I wouldn't rely on sys.partitions to gauge whether a table is completely empty or not. Maybe just me. Just out of curiosity, what if a table load...

If it's not a system db, you can move db files by specifying a new location for the file, setting the db offline, physically moving the file(s), and finally setting...

No. But maybe you could create your own view with a similar name -- such as dbo.sysusers2 -- and change your code to use the view name?

create view dbo.sysusers2...

I view it differently, since I prefer a code-based solution to a gui-based solution.

Here's the code you're not looking for 😉

/* drop empty "MyTable%" tables */

DECLARE @exec_sql bit

DECLARE @print_sql bit

DECLARE @sql nvarchar(4000)

DECLARE @table_has_row bit

DECLARE @table_name nvarchar(128)

SET @exec_sql = 0

SET @print_sql = 1

DECLARE cursor_tables...

Also, be aware that some plans are never cached at all, for example, a trivial plan to satisfy "select * from table_name".

Sergiy (9/21/2016)

---

Be aware that conversion of varchars to datetimes by style "120" is locale dependent.

On different server settings you may get different results:

SET DATEFORMAT DMY

SELECT CONVERT(VARCHAR(20), CONVERT(datetime,CAST('2016-08-10 05:29:27' as datetime),112),...

You can use CONVERT to format 120 to do that:

select '='+senddate+'=' AS [original char format], convert(varchar(19), SendDate, 120) AS [yyyy-mm-dd hh:mm:ss]

from (

select convert(nvarchar(4000), GETDATE(), 121) as...

Alexander Suprun (9/16/2016)

---

I think you overstate the importance of the clustered index, especially in this case. Clustered index doesn't really matter too much here. The one you suggested will be...

I also don't see a need to split the entire string in this case, since you all want to extract is the CN= name.

SELECT

string,

...

Alexander Suprun (9/19/2016)

---

Since when SQL Server...