Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««3,9323,9333,9343,9353,936»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Friday, April 05, 2013 7:55 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:31 AM
Points: 14,788, Visits: 27,263
ChrisM@Work (4/5/2013)
Grant Fritchey (4/5/2013)
ChrisM@Work (4/5/2013)

Not sure how it will pan out yet. With a couple of good mates in the immediate area and a nearby pub boasting 180 different whiskies, it's a tough choice


Excellent. It's settled then. I'm staying with you.


Sure you want to sample all of those whiskies the night before a presentation?


Edited for privacy.


All? Nah. Half maybe.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1439229
Posted Friday, April 05, 2013 8:01 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 8:20 PM
Points: 32,764, Visits: 14,928
Cadavre (4/5/2013)
rodjkidd (4/4/2013)
Hotel booked for SQLBits. Almost forgot all about that so a nice refreshing 20 minute walk in the morning!


I'm in Castle Marina Premier Inn, which according to Google maps is 2.6 miles away by car or a 45 minute walk


I'm at the Hilton brand hotel somewhere nearby.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1439230
Posted Friday, April 05, 2013 8:09 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 10:37 AM
Points: 2,844, Visits: 4,826
Steve Jones - SSC Editor (4/5/2013)
Cadavre (4/5/2013)
rodjkidd (4/4/2013)
Hotel booked for SQLBits. Almost forgot all about that so a nice refreshing 20 minute walk in the morning!


I'm in Castle Marina Premier Inn, which according to Google maps is 2.6 miles away by car or a 45 minute walk


I'm at the Hilton brand hotel somewhere nearby.


Cool. Steve are you about for the whole event or just the Friday?

Chris, Grant and Cadavre are you all about for the 3 days or not?

Rodders...



Post #1439239
Posted Friday, April 05, 2013 8:37 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:17 AM
Points: 2,403, Visits: 7,308
rodjkidd (4/5/2013)
Chris, Grant and Cadavre are you all about for the 3 days or not?

Rodders...


I'm not going to the Thursday, but will be getting to my hotel sometime in the afternoon.

I'm there for the whole of the Friday sessions and undecided about the Saturday sessions. I'll be going to the morning, because there are three talks in the 8:10-9:10 block that I want to see. Won't be making my decision on that until the day. Not sure about staying for the whole Saturday, but even if I do, I'm travelling back home Saturday so won't be sticking around.



Not a DBA, just trying to learn

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better, quicker answers on SQL Server performance related questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/



If you litter your database queries with nolock query hints, are you aware of the side effects?
Try reading a few of these links...

(*) Missing rows with nolock
(*) Allocation order scans with nolock
(*) Consistency issues with nolock
(*) Transient Corruption Errors in SQL Server error log caused by nolock
(*) Dirty reads, read errors, reading rows twice and missing rows with nolock


LinkedIn | Blog coming soon (for sufficiently large values of "soon" )!
Post #1439257
Posted Friday, April 05, 2013 8:41 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:31 AM
Points: 14,788, Visits: 27,263
rodjkidd (4/5/2013)
Steve Jones - SSC Editor (4/5/2013)
Cadavre (4/5/2013)
rodjkidd (4/4/2013)
Hotel booked for SQLBits. Almost forgot all about that so a nice refreshing 20 minute walk in the morning!


I'm in Castle Marina Premier Inn, which according to Google maps is 2.6 miles away by car or a 45 minute walk


I'm at the Hilton brand hotel somewhere nearby.


Cool. Steve are you about for the whole event or just the Friday?

Chris, Grant and Cadavre are you all about for the 3 days or not?

Rodders...


I'm pretty sure Steve & I get there Thursday night. I'm flying out Sunday, so just two days for me.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1439258
Posted Friday, April 05, 2013 8:43 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:01 AM
Points: 6,742, Visits: 12,834
rodjkidd (4/5/2013)
Steve Jones - SSC Editor (4/5/2013)
Cadavre (4/5/2013)
rodjkidd (4/4/2013)
Hotel booked for SQLBits. Almost forgot all about that so a nice refreshing 20 minute walk in the morning!


I'm in Castle Marina Premier Inn, which according to Google maps is 2.6 miles away by car or a 45 minute walk


I'm at the Hilton brand hotel somewhere nearby.


Cool. Steve are you about for the whole event or just the Friday?

Chris, Grant and Cadavre are you all about for the 3 days or not?

Rodders...


Arrive late friday for the saturday sessions, probably leave late saturday.


“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Exploring Recursive CTEs by Example Dwain Camps
Post #1439259
Posted Friday, April 05, 2013 9:12 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:17 AM
Points: 2,403, Visits: 7,308
Steve Jones - SSC Editor (4/5/2013)
Cadavre (4/5/2013)
rodjkidd (4/4/2013)
Hotel booked for SQLBits. Almost forgot all about that so a nice refreshing 20 minute walk in the morning!


I'm in Castle Marina Premier Inn, which according to Google maps is 2.6 miles away by car or a 45 minute walk


I'm at the Hilton brand hotel somewhere nearby.


I looked at the Hilton, it's about an extra mile further away and cost more to stay in it so I decided against it.



Not a DBA, just trying to learn

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better, quicker answers on SQL Server performance related questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/



If you litter your database queries with nolock query hints, are you aware of the side effects?
Try reading a few of these links...

(*) Missing rows with nolock
(*) Allocation order scans with nolock
(*) Consistency issues with nolock
(*) Transient Corruption Errors in SQL Server error log caused by nolock
(*) Dirty reads, read errors, reading rows twice and missing rows with nolock


LinkedIn | Blog coming soon (for sufficiently large values of "soon" )!
Post #1439276
Posted Friday, April 05, 2013 1:20 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 9:47 PM
Points: 22,472, Visits: 30,138
Here is what I really want to say in response to the OPs last post in another thread:
sql-lover (4/5/2013)
GilaMonster (4/5/2013)
sql-lover (4/5/2013)
So I wanted to open a case and review, without paying, but don't know the process or link to follow.


If you want to log a case with product support, you will have to pay for it. There are some cases where if it's a new bug they don't charge, but that's the exception. Basically, unless you have premier support or some free support cases from MSDN subscription, opening a case will cost.

See the Assisted Support Options on this page:
http://support.microsoft.com/ph/1044/en-us


Hmm, I see...

So, if my Cluster is experiencing issue addressed by KB2718576. How can I be 100% sure that's the case? rely on myself? ... I mean, it was fully patched, SAN is an approved hardware and fully patched as well. I see no other explanation, based on what happened, but apply the hotfix.

I just want to make use of the rights I have as a legit software owner. MS products are not cheap and come with warranty.


Be sure you read the entire EULA. Also understand you don't really own the software but license it from Microsoft.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1439447
Posted Friday, April 05, 2013 2:37 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:06 PM
Points: 41,495, Visits: 34,416
Am I the only person who gets 'I don't think that's true' replies to their posts from a certain person and am I the only one annoyed by it?

I can justify and explain just about anything I state here, but sometimes the time required to produce a detailed counter-claim is just too much.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1439487
Posted Friday, April 05, 2013 2:43 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 9:47 PM
Points: 22,472, Visits: 30,138
GilaMonster (4/5/2013)
Am I the only person who gets 'I don't think that's true' replies to their posts from a certain person and am I the only one annoyed by it?

I can justify and explain just about anything I state here, but sometimes the time required to produce a detailed counter-claim is just too much.


Nope. I get just as annoyed by most of that individuals posts.




Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1439491
« Prev Topic | Next Topic »

Add to briefcase «««3,9323,9333,9343,9353,936»»»

Permissions Expand / Collapse