Viewing 15 posts - 1,681 through 1,695 (of 2,458 total)
I reject any code using either sp_MSforeachdb or sp_MSforeach_worker as these do not meet the standards I'm enforcing,
+1
-- Itzik Ben-Gan 2001
March 24, 2015 at 4:39 pm
Luis Cazares (3/24/2015)
WITH Letters AS(
SELECT TOP 26 CHAR(ROW_NUMBER() OVER(ORDER BY (SELECT NULL)) + 64) letter
FROM sys.all_columns
)
SELECT DISTINCT n.*...
-- Itzik Ben-Gan 2001
March 24, 2015 at 4:05 pm
SQL_Surfer (3/24/2015)
-- Itzik Ben-Gan 2001
March 24, 2015 at 3:59 pm
I used to use the DTA back some years back but, for me, have gotten more bang for my buck by running DMV queries to find my longest running queries...
-- Itzik Ben-Gan 2001
March 24, 2015 at 3:27 pm
ZZartin (3/24/2015)
Based on what you have posted, these indexes are not helping you in any way. Indexes speed up reads and slow down modifications. In other words an index, when...
-- Itzik Ben-Gan 2001
March 24, 2015 at 12:12 pm
MadAdmin (3/24/2015)
In addition to TheSqlGuru's great advice,
before you drop indexes, take note that there are some heroes who do silly things like drop and create indexes in SSIS...
-- Itzik Ben-Gan 2001
March 24, 2015 at 12:02 pm
... and since this is such an important topic I thought I'd do quick test to demonstrate.
For the first test we'll INSERT 500,000 rows into a table without an...
-- Itzik Ben-Gan 2001
March 24, 2015 at 11:38 am
Sapen (3/24/2015)
Alan.B (3/23/2015)
Although the user seeks, user scans and userlookups are all 0 the user updates is definitely a lot. I am thinking to speed up updates on subscriber these...
-- Itzik Ben-Gan 2001
March 24, 2015 at 10:43 am
I used a temp variable in my solution below for sample data so that you can just run this in SSMS. The SELECT statement is what you're looking for.
DECLARE...
-- Itzik Ben-Gan 2001
March 24, 2015 at 12:29 am
The problem is that the @TABLE_STYLE variable is a fed to an inline style which means the style can't include style tags. E.g. "style = {Font-family: arial; color: red}"
A style...
-- Itzik Ben-Gan 2001
March 24, 2015 at 12:17 am
My apologies - I misread you original post a little. I was under the impression that some of these indexes were 10% fragmented weekly, not more than 10% as you...
-- Itzik Ben-Gan 2001
March 23, 2015 at 5:07 pm
I just had an external Vendor call and mention they want to change the Fill Factor setting for a server.
In my experience it's better to leave the the server setting...
-- Itzik Ben-Gan 2001
March 23, 2015 at 3:21 pm
Although the user seeks, user scans and userlookups are all 0 the user updates is definitely a lot. I am thinking to speed up updates on subscriber these indexes are...
-- Itzik Ben-Gan 2001
March 23, 2015 at 2:59 pm
Phil Parkin (5/3/2009)
Have a look here for an example of how it can be done.http://blogs.conchango.com/jamiethomson/archive/2006/07/11/4209.aspx
Blog is down :crying:
-- Itzik Ben-Gan 2001
March 23, 2015 at 1:48 pm
Forgive me if I'm wrong (it's been a while and I'm going by memory here). You can go to Start > Run (or Windows key + R in windows 8+)...
-- Itzik Ben-Gan 2001
March 20, 2015 at 1:55 pm
Viewing 15 posts - 1,681 through 1,695 (of 2,458 total)