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...

You might need to do the "script out existing nonclustered indexes, create a new table with identical structure -- except with the clus index (only) in place, of course --...

The single most important performance factor for most tables is how they are clustered. You may add non-clustered indexes, typically covering indexes, but the best clustering is the big...

Phil Parkin (9/15/2016)

---

Brandie Tarvin (9/15/2016)

---

Fast.Eddie (9/7/2016)

---

Good Afternoon All, This is my first post.

I created the below code and if works fine. However my DBA said "It does the job but...

Back to the original post, that code looks far better than most of what I see as a DBA!

Just one serious change, to get rid of the CAST of/function against...

Keep in mind, though, that you could use non-temp table names in tempdb. Tables will have slightly less overhead in tempdb.