Sigh...I wish I could filter out old threads.

You'll end up trading key lookups for RID lookups which are the same as far as...

Tac11 (5/10/2016)

---

I have a table with 8 million rows (index size 1.5 GB and Data space 1.3 GB). when I ran index_usage_stats results came with

Index id = 1 (datatype...

Trying to institute culture change is probably the hardest things I've ever had to do.

They might not like it but...

In my experience I've seen many create one schedule for each job. However, 1 schedule can have many jobs associated with it. As you observed nothing stops you...

It's a custom function that you have to create on your...

Here is a simple example on how to grab ALL text before the semicolon. Just keep in mind this implies that there will always be a semicolon to use...

Just Arthritis? After the semicolon perhaps? This is easy to do but I don't want to give you a bad solution. Please provide sample data and how...

Note: This is a very old thread.

Did you just try right clicking on a job and select 'Script Job as' option?

It won't help you with synching jobs but that's not something I would normally want to...

Thanks for the tip! I've...

If you are asking if it's a good idea to use 'sp_msforeachdb' you just have to keep in mind that it's an undocumented procedure. So you never know how...

Do you care about running that against any other possible db's? You might want something a little more generic.

DECLARE @strings TABLE (LoginID VARCHAR(100))

INSERT INTO @strings

VALUES ('adventure-works\peter0'), ('Northwind\mary0'), ('Test\mark1')

SELECT

SUBSTRING(LoginID,CHARINDEX('\', LoginID)...

You can also pull all kinds of useful information from SERVERPROPERTY.

SELECT

SERVERPROPERTY('ProductVersion') AS ProductVersion,

SERVERPROPERTY('Edition') AS Edition

If you don't know the product name from the major builds versions you can always check...

Luis beat me to the sample data speech...but that being said I would advise not to use ordinal position in your ORDER BY clause. It's a bad habit to...