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,9313,9323,9333,9343,935»»»

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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:06 AM
Points: 2,404, Visits: 7,311
I only run when the ice cream van drives away


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 #1439185
Posted Friday, April 05, 2013 6:58 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:33 AM
Points: 6,754, Visits: 12,854
rodjkidd (4/5/2013)
Cadavre (4/5/2013)
rodjkidd (4/5/2013)
Nice.

So I take it you will jogging there and back then?

I hate distances like that. Too far to walk, to short a drive for the car to get warmed up, engine and heater that is!

Rodders...


I most certainly will not be jogging! I don't know how I'm getting back and fourth though. . . I can't justify driving unless the weather is terrible because it's too close, but I've never been to Nottingham so a walk will probably just involve me getting lost

ChrisM@Work (4/5/2013)
Might try booking there this weekend. I stayed a couple of nights at a Premier Inn 10 miles away at East Midlands airport recently and in Birmingham two weeks ago and they were both memorable - great staff, awesome grub, perfectly acceptable rooms.


Touch wood, I've not stayed in a bad one. I use them whenever I need to visit a client, or visiting family, or having a night out, or weekend away etc etc


Well you could always join Steve Jones as he does like his morning run! Only joking. That will be an interesting walk back if you are planning on getting "involved" with the evenings activities

I would have thought there will be a few people staying there so a car / taxi share might be on the cards.

Not been to that part of Nottingham, so no idea how easy it is to get lost around there.

But Chris will keep you company at least!

Rodders...


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


“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 #1439186
Posted Friday, April 05, 2013 7:05 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:30 PM
Points: 14,802, Visits: 27,275
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.


----------------------------------------------------
"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 #1439190
Posted Friday, April 05, 2013 7:13 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:06 AM
Points: 2,404, Visits: 7,311
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


Does 30 miles constitute nearby? In that case, I'm staying next door to the conference!



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 #1439196
Posted Friday, April 05, 2013 7:13 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:33 AM
Points: 6,754, Visits: 12,854
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.


“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 #1439197
Posted Friday, April 05, 2013 7:22 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:33 AM
Points: 6,754, Visits: 12,854
Cadavre (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


Does 30 miles constitute nearby? In that case, I'm staying next door to the conference!


13.9 miles. You have to like your whisky.


“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 #1439203
Posted Friday, April 05, 2013 7:27 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:06 AM
Points: 2,404, Visits: 7,311
ChrisM@Work (4/5/2013)
13.9 miles. You have to like your whisky.


Evidently my geography is a little off



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 #1439206
Posted Friday, April 05, 2013 7:29 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:33 AM
Points: 6,754, Visits: 12,854
Cadavre (4/5/2013)
ChrisM@Work (4/5/2013)
13.9 miles. You have to like your whisky.


Evidently my geography is a little off


You've been spending waaaay too much time in front of a computer


“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 #1439209
Posted Friday, April 05, 2013 7:34 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:06 AM
Points: 2,404, Visits: 7,311
ChrisM@Work (4/5/2013)
You've been spending waaaay too much time in front of a computer


I can find at least one person that would not only agree with you, but would print this forum post off and wave it in my face whenever I sat down to play with my home lab



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 #1439211
Posted Friday, April 05, 2013 7:36 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:33 AM
Points: 6,754, Visits: 12,854
Cadavre (4/5/2013)
ChrisM@Work (4/5/2013)
You've been spending waaaay too much time in front of a computer


I can find at least one person that would not only agree with you, but would print this forum post off and wave it in my face whenever I sat down to play with my home lab

Better quickly copy it then - before you edit it so they can't


“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 #1439212
« Prev Topic | Next Topic »

Add to briefcase «««3,9313,9323,9333,9343,935»»»

Permissions Expand / Collapse