I think the larger problem is just getting a list of stats from systables from each DB.

Do this

create table tempdb.dbo.MyStats( DBname sysname,tablename sysname,rows bigint)

EXEC sp_MSforeachdb 'USE ? insert into tempdb.dbo.MyStats...

How about doing an

update VendorCostPrefix09_ set SetCost=value, SetPrefix=Prefix--

where setcost <> value or setprefix<>prefix

Could be you are updating the entire table where maybe only 20 rows actually need the update.

Since...

looks like you are joining data sets between linked servers.

Try selecting the data into a temp table first before doing the ANSI-1989 old school style joins with unions.

You seem to get Model_Id from a window and pass it up to an outer window, and that value does not get used in a filter, join or select on...

Try using this query.

It should bring back info like, table, indexname, indexkey together with included columns, seeks, scans, lookups, rowlockcounts, rowblock counts, rowblock duration, page lock counts etc all together...

The table you gave us has

create table

.

.

[WEEKDAY_NUMBER] [int] NOT NULL,

.

.

INSERT INTO Date (DAY_WID, DAY_Date)

VALUES ('19000101','19000101') --9999-12-31 failed

Since you are not inserting into weekday_number, the insert must break.

This will...

I think the improvement is solely due to the changing of the clusterd index to be the date key as the non clustered index on date probably would not have...

Jacob Wilkins (5/1/2015)

---

As I understand it, you probably should run CHECKDB against tempdb, since corruption can occur, and the files aren't zeroed out on restart, so the corruption can stick...

GilaMonster (5/1/2015)

---

Not for the reason you posted.

Temp table caching is a feature, it's designed to reduce the overhead when...

I would [select object_name(id),* from sysindexes where object_name(id) = 'mytable'] or [select object_name(object_id),* from sys.indexes where object_name(object_id) = 'mytable'] to find the fillfactor.

completely script out all the indexes on...

will this work?

SELECT RecordID, contactID, forename, surname, cliNumber, ranked_value

FROM ( SELECT RecordID, contactID, forename, surname,

...

I somehow forced the sort to be earlier by doing this

DECLARE @id INT = DB_ID('MyDB')

SELECT DISTINCT

SP.spid, LoginId = LEFT(SP.loginame, 50), HostName =...

If you specify PF within table definition, it automatically marks the columns as not null.

If you don't, then you have to specify not null for each column first so that...

ramana3327 (4/30/2015)

---

Hi,

One of our Production database is using default isolation Readcommitted.

The transactions also using readcommitted. But we want change isolation level to read comitted snapshot isolation and test it to...

http://www.brentozar.com/archive/2013/01/implementing-snapshot-or-read-committed-snapshot-isolation-in-sql-server-a-guide/