SQLRNNR

Forum Replies Created

Viewing 15 posts - 4,411 through 4,425 (of 19,560 total)

RE: Today's Random Word!

The Dixie Flatline (7/26/2013)
SQLRNNR (7/26/2013)
crookj (7/26/2013)
SQLRNNR (7/26/2013)
Revenant (7/26/2013)
The Dixie Flatline (7/26/2013)
opc.three (7/26/2013)
SQLRNNR (7/26/2013)
bcsims 90437 (7/26/2013)
Daniel Bowlin (7/26/2013)
crookj (7/26/2013)
SQLRNNR (7/25/2013)
The Dixie Flatline (7/25/2013)
SQLRNNR (7/25/2013)
Revenant (7/25/2013)
L' Eomot Inversé (7/25/2013)
SQLRNNR (7/25/2013)
REDNECK
B3 deficiency?
Pellagra
Alabama Clay
Georgia...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

July 26, 2013 at 1:45 pm

#1636310
RE: SELECT StatMan

HildaJ (7/26/2013)
I'm not sure if there's a problem, I have not seen this query before and I was inquiring information about it. I see now that updating statistics generates...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

July 26, 2013 at 1:42 pm

#1636309
RE: Could You Live Like a DBA?

Revenant (7/26/2013)
SQLRNNR (7/26/2013)
I really do think google would be easier if I could do this:
select * from closeby_restaurants where cuisine = 'chinese' and distance_from_home <= 2 miles and deliciousness =...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

July 26, 2013 at 12:58 pm

#1636296
RE: Database File Autogrowth

Do you have an index maintenance routine running on Sundays?
Do you have a very large batch job that runs on Sundays that might possibly create and drop tables?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

July 26, 2013 at 12:51 pm

#1636292
RE: Today's Random Word!

crookj (7/26/2013)
SQLRNNR (7/26/2013)
Revenant (7/26/2013)
The Dixie Flatline (7/26/2013)
opc.three (7/26/2013)
SQLRNNR (7/26/2013)
bcsims 90437 (7/26/2013)
Daniel Bowlin (7/26/2013)
crookj (7/26/2013)
SQLRNNR (7/25/2013)
The Dixie Flatline (7/25/2013)
SQLRNNR (7/25/2013)
Revenant (7/25/2013)
L' Eomot Inversé (7/25/2013)
SQLRNNR (7/25/2013)
REDNECK
B3 deficiency?
Pellagra
Alabama Clay
Georgia Peaches
Don't ever cross them...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

July 26, 2013 at 12:49 pm

#1636290
RE: SELECT StatMan

The cause for it to not select some tables is likely due to how your code is written.
Please provide the entire code that is generating your update stats so we...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

July 26, 2013 at 12:48 pm

#1636289
RE: Could You Live Like a DBA?

I really do think google would be easier if I could do this:
select * from closeby_restaurants where cuisine = 'chinese' and distance_from_home <= 2 miles and deliciousness = 'awesome' and...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

July 26, 2013 at 11:54 am

#1636270
RE: What is the set up to study 70-432?

FWIW - I have a Virtual Lab setup on my laptop.
1 DC
2 SAN VMs (freesan, 1 demo and 1 live)
1 Cluster (2 boxes)
2 stand alone sql servers (1 sql 2012...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

July 26, 2013 at 11:35 am

#1636259
RE: Subscriptions Monitoring query

Thanks for the query
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

July 26, 2013 at 11:26 am

#1636257
RE: Today's Random Word!

Revenant (7/26/2013)
The Dixie Flatline (7/26/2013)
opc.three (7/26/2013)
SQLRNNR (7/26/2013)
bcsims 90437 (7/26/2013)
Daniel Bowlin (7/26/2013)
crookj (7/26/2013)
SQLRNNR (7/25/2013)
The Dixie Flatline (7/25/2013)
SQLRNNR (7/25/2013)
Revenant (7/25/2013)
L' Eomot Inversé (7/25/2013)
SQLRNNR (7/25/2013)
REDNECK
B3 deficiency?
Pellagra
Alabama Clay
Georgia Peaches
Don't ever cross them - you...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

July 26, 2013 at 11:24 am

#1636255
RE: Are the posted questions getting worse?

Jeff Moden (7/26/2013)
L' Eomot Inversé (7/24/2013)
I haven't got enough hair to have bad hair days 🙂
BWAAA-HAAA!!! I've got tons of hair. I'm just not allowed to show it...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

July 26, 2013 at 11:23 am

#1636254
RE: Today's Random Word!

bcsims 90437 (7/26/2013)
Daniel Bowlin (7/26/2013)
crookj (7/26/2013)
SQLRNNR (7/25/2013)
The Dixie Flatline (7/25/2013)
SQLRNNR (7/25/2013)
Revenant (7/25/2013)
L' Eomot Inversé (7/25/2013)
SQLRNNR (7/25/2013)
REDNECK
B3 deficiency?
Pellagra
Alabama Clay
Georgia Peaches
Don't ever cross them - you could be in a world of...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

July 26, 2013 at 9:52 am

#1636216
RE: Need Help Urgently

dwain.c (7/25/2013)
SQLRNNR (7/25/2013)
dwain.c (7/25/2013)
SQLRNNR (7/25/2013)
dwain.c (7/25/2013)
Something like this should list out any of the products that fail your audit.
WITH ValidationTables (n, )
SELECT 1, [Key] FROM A
...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

July 25, 2013 at 11:12 pm

#1636036
RE: Need Help Urgently

dwain.c (7/25/2013)
SQLRNNR (7/25/2013)
dwain.c (7/25/2013)
Something like this should list out any of the products that fail your audit.
WITH ValidationTables (n, )
SELECT 1, [Key] FROM A
...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

July 25, 2013 at 11:01 pm

#1636034
RE: Need Help Urgently

dwain.c (7/25/2013)
Something like this should list out any of the products that fail your audit.
WITH ValidationTables (n, )
SELECT 1, [Key] FROM A
UNION...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

July 25, 2013 at 10:54 pm

#1636031

Viewing 15 posts - 4,411 through 4,425 (of 19,560 total)