Viewing 15 posts - 136 through 150 (of 607 total)
Ed Wagner (11/18/2013)
Sean Pearce (11/18/2013)
Ed Wagner (11/16/2013)
L' Eomot Inversé (11/15/2013)
Revenant (11/15/2013)
crookj (11/15/2013)
Kurt W. Zimmerman (11/15/2013)
L' Eomot Inversé (11/15/2013)
Ed Wagner (11/15/2013)
L' Eomot Inversé (11/14/2013)
Ed Wagner (11/14/2013)
whereisSQL? (11/13/2013)
DeleteJunk
Food
Cooking
Accountancy
Books
Doc Savage
paperback
pulp fiction
John Travolta
Grease
Lightening
McQueen
November 18, 2013 at 5:58 am
Shadab Shah (11/18/2013)
On which column should one create index if no WHERE clause is specified.
example
Select * from table_name
No identity column is present on the...
November 18, 2013 at 3:21 am
Ed Wagner (11/16/2013)
L' Eomot Inversé (11/15/2013)
Revenant (11/15/2013)
crookj (11/15/2013)
Kurt W. Zimmerman (11/15/2013)
L' Eomot Inversé (11/15/2013)
Ed Wagner (11/15/2013)
L' Eomot Inversé (11/14/2013)
Ed Wagner (11/14/2013)
whereisSQL? (11/13/2013)
DeleteJunk
Food
Cooking
Accountancy
Books
Doc Savage
paperback
pulp fiction
John Travolta
Grease
November 18, 2013 at 2:57 am
TeraByteMe (11/15/2013)
November 18, 2013 at 2:35 am
Backups and restores are already logged in msdb.
http://technet.microsoft.com/en-us/library/ms188062.aspx.
You can run a server side trace to capture sql statements executed on an instance.
November 18, 2013 at 2:19 am
shew (11/14/2013)
Another concern is that we have two scheduled instance failovers a week so that our clusters can be patched during established time frames, which means that around 2,000 identity...
November 15, 2013 at 5:46 am
SELECT COALESCE(table1.expdate, table2.expdate, '2099-12-31') as enddate
November 13, 2013 at 5:01 am
Hi,
Your example shows that the insert with IGNORE_DUP_KEY = ON produces a much more complicated query plan because it needs to filter out the duplicates before performing the insert. This...
November 13, 2013 at 4:54 am
Koen Verbeeck (11/13/2013)
Secondly, developer is the same as enterprise feature-wise,...
November 13, 2013 at 1:21 am
JAZZ Master (11/12/2013)
Ed Wagner (11/12/2013)
Revenant (11/11/2013)
RBarryYoung (11/11/2013)
Ed Wagner (11/11/2013)
L' Eomot Inversé (11/11/2013)
SQLRNNR (11/11/2013)
buzzAudio (HTML5)
Video
Daddy-o!
Tally ho!
Split
logs
lumberjack
November 12, 2013 at 6:40 am
Ed Wagner (11/11/2013)
Revenant (11/11/2013)
Sean Pearce (11/11/2013)
Ed Wagner (11/11/2013)
crookj (11/11/2013)
SQLRNNR (11/11/2013)
buzzSaw
Chain
Motorcycle
Ride
Free
MySql
November 11, 2013 at 12:32 pm
Ed Wagner (11/11/2013)
crookj (11/11/2013)
SQLRNNR (11/11/2013)
buzzSaw
Chain
Motorcycle
November 11, 2013 at 10:11 am
Express12 (11/11/2013)
Do you guys have a recommendation on a new flavor of a "smart reindex" process out there?
The general recommendation is Ola Hallengren's maintenance scripts. http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html
November 11, 2013 at 10:11 am
Your code compiles fine on my 2012 instance
November 11, 2013 at 7:50 am
The maths is not correct. Try this in your CTE.
WITH core AS (
SELECT DISTINCT
s.volume_mount_point [Drive],
s.available_bytes / 1024 / 1024 [AvailableMBs],
s.total_bytes / 1024 / 1024 [TotalMBs],
(s.available_bytes / 1024. / 1024) /...
November 11, 2013 at 7:33 am
Viewing 15 posts - 136 through 150 (of 607 total)