Viewing 15 posts - 976 through 990 (of 7,488 total)
There can be dosens of reasons why a plan will get invalidated.
e.g. changes to indexes (rebuilds), create/drop index, statistics update, ...
Compare the old and the new plan...
May 5, 2017 at 3:56 am
Thank you, Gail
In the mean while I stumbled upon this myth article covering the topic I've been pondering over.
SQL Server Urban Legend: SQL Server Uses...
April 20, 2017 at 11:52 pm
First I believe someone just ran DTA and created all indexes and statistics that tool suggested.
Result:
- Way to many indexes
- user defined statistics
Also: having...
April 13, 2017 at 6:04 am
You are using a view which calculates the value of a column you are using as a predicate in your original query.
So to be able to filter the result...
April 13, 2017 at 3:41 am
you do realize that your view is to be materialized due to all the functions you are performing in it to determin the content for colum C_Date, right ?
April 13, 2017 at 3:06 am
just a little caution:
If you have an alert activating a job, and you disable the job without disabling the alert, your SQLAGENT.OUT file will explode because it still...
April 13, 2017 at 1:45 am
Avoid the trace flag. (as it is no longer a tweek) Use the configuration setting.
April 5, 2017 at 8:07 am
FYI, we recently discovered a heap table, with no indexes at all, consuming 56GB having only +/-40000 rows of 64bytes.
(SQL2014 SP2CU3)
After 'alter table x REBUILD', consumption got back...
April 4, 2017 at 5:40 am
A couple of years ago I started pistol target shooting, because that needs a focussed mind. It worked very well.
Nowadays, I find my best relaxation doing mantrailing...
March 31, 2017 at 12:52 am
..
UPDATE ED
SET ED.ID = ET.SID,
ED.Code = ET.TCode,
FROM dbo.Emp ED
INNER JOIN dbo.EXt ET
ON...
March 30, 2017 at 1:01 am
There's the main difference between log shipping and db mirroring !
see = "... A log shipping process is always unidirectional ....."
Also have a...
March 27, 2017 at 1:36 am
If you have your files set to Autogrow: Check your default traces, they contain info on automatic file growth !
/*
* read SQL default trace...
March 27, 2017 at 1:22 am
ALTER COLUMN: https://msdn.microsoft.com/en-us/library/ms190273.aspx
"Modify columns" https://msdn.microsoft.com/en-us/library/ms190259.aspx
implicit conversions https://msdn.microsoft.com/en-us/library/ms187928.aspx
March 17, 2017 at 12:52 am
Viewing 15 posts - 976 through 990 (of 7,488 total)