Viewing 15 posts - 1,681 through 1,695 (of 2,462 total)
Had a few moments to kill...
USE tempdb
GO
-- It's always good to provide sample data in an easily usable format like so
CREATE TABLE dbo.
([year] int not null,
Client_Name varchar(100) not...
-- Itzik Ben-Gan 2001
March 26, 2015 at 12:16 pm
PHYData DBA (3/24/2015)
Alan.B (3/23/2015)
-- Itzik Ben-Gan 2001
March 26, 2015 at 10:31 am
SELECT * FROM
(
SELECT LocationID, LanguageID ,LocationLanguageRecID,
row_number() over (partition by LOCATIONID
order by LocationLanguageRecID) LineNumber
FROM LocationLanguages
) X
WHERE LineNumber = 2
-- Itzik Ben-Gan 2001
March 24, 2015 at 6:56 pm
Luis Cazares (3/24/2015)
Alan.B (3/24/2015)
Luis Cazares (3/24/2015)
WITH Letters AS(
SELECT TOP 26 CHAR(ROW_NUMBER() OVER(ORDER BY (SELECT NULL)) + 64) letter
FROM...
-- Itzik Ben-Gan 2001
March 24, 2015 at 4:41 pm
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
Viewing 15 posts - 1,681 through 1,695 (of 2,462 total)