Sean Pearce

Forum Replies Created

Viewing 15 posts - 136 through 150 (of 608 total)

RE: Today's Random Word!

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)
Delete
Junk
Food
Cooking
Accountancy
Books
Doc Savage
paperback
pulp fiction
John Travolta
Grease
Lightening
McQueen
The SQL Guy @ blogspot[/url]
@SeanPearceSQL
About Me[/url]

November 18, 2013 at 5:58 am

#1667114
RE: On which column to create index if no where clause is present ?

Shadab Shah (11/18/2013)
Hi Experts,
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...
The SQL Guy @ blogspot[/url]
@SeanPearceSQL
About Me[/url]

November 18, 2013 at 3:21 am

#1667062
RE: Today's Random Word!

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)
Delete
Junk
Food
Cooking
Accountancy
Books
Doc Savage
paperback
pulp fiction
John Travolta
Grease
The SQL Guy @ blogspot[/url]
@SeanPearceSQL
About Me[/url]

November 18, 2013 at 2:57 am

#1667057
RE: filter behaving differently from query analyser versus when called through sproc

TeraByteMe (11/15/2013)
Using the term "Where Filter" is a pretty common way of referring to the WHERE clause conditiional filter. It maybe shorthand'ish but I don't see how anyone without putting...
The SQL Guy @ blogspot[/url]
@SeanPearceSQL
About Me[/url]

November 18, 2013 at 2:35 am

#1667052
RE: Audit tasks

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.
The SQL Guy @ blogspot[/url]
@SeanPearceSQL
About Me[/url]

November 18, 2013 at 2:19 am

#1667051
RE: SQL Server 2012 Gotcha with Identity Column

shew (11/14/2013)
Gail,
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...
The SQL Guy @ blogspot[/url]
@SeanPearceSQL
About Me[/url]

November 15, 2013 at 5:46 am

#1666700
RE: case with if ?

SELECT COALESCE(table1.expdate, table2.expdate, '2099-12-31') as enddate
The SQL Guy @ blogspot[/url]
@SeanPearceSQL
About Me[/url]

November 13, 2013 at 5:01 am

#1666009
RE: Tablas con índice y opción IGNORE_DUP_KEY=ON problemas en los bloqueos al insertar en la tabla

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...
The SQL Guy @ blogspot[/url]
@SeanPearceSQL
About Me[/url]

November 13, 2013 at 4:54 am

#1666008
RE: Data Compression

Koen Verbeeck (11/13/2013)
First of all, this question is way too easy. Enterprise has all the features, so you don't even have to think.
Secondly, developer is the same as enterprise feature-wise,...
The SQL Guy @ blogspot[/url]
@SeanPearceSQL
About Me[/url]

November 13, 2013 at 1:21 am

#1665941
RE: Today's Random Word!

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)
buzz
Audio (HTML5)
Video
Daddy-o!
Tally ho!
Split
logs
lumberjack
The SQL Guy @ blogspot[/url]
@SeanPearceSQL
About Me[/url]

November 12, 2013 at 6:40 am

#1665714
RE: Today's Random Word!

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)
buzz
Saw
Chain
Motorcycle
Ride
Free
MySql
The SQL Guy @ blogspot[/url]
@SeanPearceSQL
About Me[/url]

November 11, 2013 at 12:32 pm

#1665555
RE: Today's Random Word!

Ed Wagner (11/11/2013)
crookj (11/11/2013)
SQLRNNR (11/11/2013)
buzz
Saw
Chain
Motorcycle
The SQL Guy @ blogspot[/url]
@SeanPearceSQL
About Me[/url]

November 11, 2013 at 10:11 am

#1665534
RE: Proc with input paramaters does not compile

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
The SQL Guy @ blogspot[/url]
@SeanPearceSQL
About Me[/url]

November 11, 2013 at 10:11 am

#1665533
RE: Proc with input paramaters does not compile

Your code compiles fine on my 2012 instance
The SQL Guy @ blogspot[/url]
@SeanPearceSQL
About Me[/url]

November 11, 2013 at 7:50 am

#1665483
RE: Unable to see the available space value in @alertMessage

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) /...
The SQL Guy @ blogspot[/url]
@SeanPearceSQL
About Me[/url]

November 11, 2013 at 7:33 am

#1665479

Viewing 15 posts - 136 through 150 (of 608 total)