InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 24 May 2012 13:54:48 GMT20http://www.sqlservercentral.com/Forums/Topic604325-61-1.aspxOkay, my google-fu is in suck mode again. Anyone have links to what the effect of using NOLOCK in your queries and why you shouldn't use them? The OP [url=http://www.sqlservercentral.com/Forums/Topic1306041-392-1.aspx][b]here[/b][/url] could use the references. For his knowledge, and perhaps to help educate the database masters where he works.Thu, 24 May 2012 13:32:05 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b]Stefan Krzywicki (5/23/2012)[/b][hr]Surely we can all just agree to hate Dallas?[/quote]NoThu, 24 May 2012 09:39:06 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b]Koen Verbeeck (5/24/2012)[/b][hr]Is this thread slowly becoming competition for this one?[url]http://www.sqlservercentral.com/Forums/Topic1303209-391-2.aspx#bm1305741[/url][/quote]Don't know, but now I have to go add [*] to all my tables...:hehe:Thu, 24 May 2012 07:25:36 GMTjcrawf02http://www.sqlservercentral.com/Forums/Topic604325-61-1.aspxIs this thread slowly becoming competition for this one?[url]http://www.sqlservercentral.com/Forums/Topic1303209-391-2.aspx#bm1305741[/url]Thu, 24 May 2012 06:08:18 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspxSSRS 2k5 assistance requested by me. I've got parameters that just won't behave. I could use a hand if any of you have both the experience and the time.[url]http://www.sqlservercentral.com/Forums/Topic1305476-1063-1.aspx[/url]Wed, 23 May 2012 19:44:23 GMTEvil Kraig Fhttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b]Lynn Pettis (5/23/2012)[/b][hr][b][i]AAARRRRRGGGGGGG!!!!!!![/i][/b]Really, [b][i]he[/i][/b] just needs to go away. He isn't helpful at all.[/quote]Is it sad that not only do I know the person you're talking about, but the post? Sadly my initial reaction was "You know that's not bad for him... wait a second..."Wed, 23 May 2012 18:34:51 GMTEvil Kraig Fhttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[b][i]AAARRRRRGGGGGGG!!!!!!![/i][/b]Really, [b][i]he[/i][/b] just needs to go away. He isn't helpful at all.Wed, 23 May 2012 17:50:49 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspxSurely we can all just agree to hate Dallas?Wed, 23 May 2012 17:10:09 GMTStefan Krzywickihttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b]Gianluca Sartori (5/22/2012)[/b][hr]Thanks everyone for the suggestions and opinions.If everything goes well, I won't be working as a trainer any more.I'm negotiating a contract as DBA/DBD. It's going to be a life change, but looks very promising.Fingers crossed.[/quote]Best of luck.I have a gripe concerning training. All too often, instructors are over-optimistic about what their class can digest in a limited amount of time. The lab exercises are so scripted that attendees don't have to think about the underlying concepts to complete them. Some "training" ends up being almost like a demo.Wed, 23 May 2012 17:06:52 GMTThe Dixie Flatlinehttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b]Steve Jones - SSC Editor (5/23/2012)[/b][hr][quote][b]Evil Kraig F (5/23/2012)[/b][hr]This isn't a psychological experiment unless you're trying to determine the psychosis of a Bronco's fan in light of the fact that their team simply sucks.[/quote]Ahem, unlike the Arizona team, we made the playoffs and went to the second round.[/quote]Ah, yes, the poor Cardinals. They are suckage. Luckily I'm not a fan. :)Wed, 23 May 2012 16:23:49 GMTEvil Kraig Fhttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b]Steve Jones - SSC Editor (5/23/2012)[/b][hr][quote][b]Evil Kraig F (5/23/2012)[/b][hr]This isn't a psychological experiment unless you're trying to determine the psychosis of a Bronco's fan in light of the fact that their team simply sucks.[/quote]Ahem, unlike the Arizona team, we made the playoffs and went to the second round.[/quote]Which used to be a Missouri tesm.Wed, 23 May 2012 15:45:28 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b]Evil Kraig F (5/23/2012)[/b][hr]This isn't a psychological experiment unless you're trying to determine the psychosis of a Bronco's fan in light of the fact that their team simply sucks.[/quote]Ahem, unlike the Arizona team, we made the playoffs and went to the second round.Wed, 23 May 2012 15:42:10 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b]Greg Edwards-268690 (5/23/2012)[/b][hr]Brett Favre retired?Oh yeah, I remember some game with the Saints.He got real old real quick with some of those hits.[/quote]He retired and retired and retired. He's still retiring from things while at home.Wed, 23 May 2012 15:18:39 GMTStefan Krzywickihttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b] Jack Corbett (5/23/2012)[/b][hr][quote][b]Stefan Krzywicki (5/23/2012)[/b][hr][quote][b]Lynn Pettis (5/23/2012)[/b][hr][quote][b]The Dixie Flatline (5/23/2012)[/b][hr]Hi Lynn.[/quote]I am not talking about he-who-is-without-clues.I am talking about someone else.[/quote]Tom Brady? He'll be retiring soon.[/quote]No, he recently said he wants to play 10 more years. If he stays healthy that seems possible. He's probably got at least 3 more years as an elite starter if he stays healthy. He also plays a more self-preserving style then Brett Favre did and he played until 40.[/quote]Yeah, but Favre was tougher than Brady. Most analysis I've seen says Brady's got 3 years in him.Wed, 23 May 2012 15:16:00 GMTStefan Krzywickihttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b]Evil Kraig F (5/23/2012)[/b][hr][quote][b]SQLRNNR (5/23/2012)[/b][hr][quote][b]SQL Kiwi (5/23/2012)[/b][hr]Bye Jason. Schoolboy error.[/quote]Nope -planned psychological experiment.[/quote]This isn't a psychological experiment unless you're trying to determine the psychosis of a Bronco's fan in light of the fact that their team simply sucks.[/quote]A true fan supports their team wether the suck or not. I am a Bronco fan, but I am not fanatic. I support my home team no matter how badly or how well they play. And I will be one of the first to tell you when the suck.Wed, 23 May 2012 15:10:31 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b]SQLRNNR (5/23/2012)[/b][hr][quote][b]SQL Kiwi (5/23/2012)[/b][hr]Bye Jason. Schoolboy error.[/quote]Nope -planned psychological experiment.[/quote]This isn't a psychological experiment unless you're trying to determine the psychosis of a Bronco's fan in light of the fact that their team simply sucks.Wed, 23 May 2012 15:05:39 GMTEvil Kraig Fhttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspxWhat are you all talking about?Oh, I see .... the "other" football, the one with the lousy-shaped ball. :-)Wed, 23 May 2012 14:57:38 GMTGianluca Sartorihttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b]SQL Kiwi (5/23/2012)[/b][hr]Bye Jason. Schoolboy error.[/quote]Nope -planned psychological experiment.Wed, 23 May 2012 14:52:15 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b]Steve Jones - SSC Editor (5/23/2012)[/b][hr][quote][b]SQLRNNR (5/23/2012)[/b][hr][quote][b]Steve Jones - SSC Editor (5/23/2012)[/b][hr][quote][b]Stefan Krzywicki (5/23/2012)[/b][hr]Tom Brady? He'll be retiring soon.[/quote]We can only hope.[/quote]Nah - I want to see him beat down the Broncos and Peyton every chance they get.That goes with every other team in the league <> Broncos[/quote]Jason will be banned from any further posting on SSC soon. Please say your farewells to him now.[/quote]Steve, go easy on him and attribute it to a temprary insanity caused by an off-season withdrawal.Wed, 23 May 2012 14:40:16 GMTRevenanthttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspxBye Jason. Schoolboy error.Wed, 23 May 2012 14:30:50 GMTSQL Kiwihttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b]SQLRNNR (5/23/2012)[/b][hr][quote][b]Steve Jones - SSC Editor (5/23/2012)[/b][hr][quote][b]Stefan Krzywicki (5/23/2012)[/b][hr]Tom Brady? He'll be retiring soon.[/quote]We can only hope.[/quote]Nah - I want to see him beat down the Broncos and Peyton every chance they get.That goes with every other team in the league <> Broncos[/quote]Jason will be banned from any further posting on SSC soon. Please say your farewells to him now.Wed, 23 May 2012 14:26:53 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b]SQLRNNR (5/23/2012)[/b][hr][quote][b]SQLRNNR (5/23/2012)[/b][hr][quote][b]Steve Jones - SSC Editor (5/23/2012)[/b][hr][quote][b]Stefan Krzywicki (5/23/2012)[/b][hr]Tom Brady? He'll be retiring soon.[/quote]We can only hope.[/quote]Nah - I want to see him beat down the Broncos and Peyton every chance they get.That goes with every other team in the league <> Broncos[/quote]Two teams I hate - Denver Broncos and Dallas Cowboys. Spillover from network tv force feeding those teams back in the day.[/quote]Well, we have one in common, the Cowboys. The other for me is the Raiders.Wed, 23 May 2012 14:22:43 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspxBrett Favre retired?Oh yeah, I remember some game with the Saints.He got real old real quick with some of those hits.Wed, 23 May 2012 14:22:35 GMTGreg Edwards-268690http://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b]Evil Kraig F (5/23/2012)[/b][hr]Pardon me, I'd just like to vent briefly about SSRS.YOU LOUSY PIECE OF DUNG INANE INTERFACE. MS ACCESS has more ability and stronger methodology than YOU! YOU ARE TRASH.Seriously. Everything in a table. EVERYTHING. Right, because in a WYSIWIG environment having to argue your way through this control to get a damnable thing done makes SO MUCH more sense than leveraging the existing strength you had in MS Access reporting where you did it so DAMN close to right (just needed optimizations).Repeating sections, controllable repeats for sections and body, direct interface inclusions and controls. No, now everything's in a table.YOU FRACKING MORONS.... We now return you to your regularly programmed inanity.[/quote]Nice rant. I agree that MS Access was a good report writing tool and in many ways superior to SSRS. I cut my teeth writing reports using Access as the front end. Not just SQL Server either. SQL Server and DB2400.Wed, 23 May 2012 14:18:49 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b]SQLRNNR (5/23/2012)[/b][hr][quote][b]Steve Jones - SSC Editor (5/23/2012)[/b][hr][quote][b]Stefan Krzywicki (5/23/2012)[/b][hr]Tom Brady? He'll be retiring soon.[/quote]We can only hope.[/quote]Nah - I want to see him beat down the Broncos and Peyton every chance they get.That goes with every other team in the league <> Broncos[/quote]Two teams I hate - Denver Broncos and Dallas Cowboys. Spillover from network tv force feeding those teams back in the day.Wed, 23 May 2012 14:17:05 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b]Stefan Krzywicki (5/23/2012)[/b][hr][quote][b]Lynn Pettis (5/23/2012)[/b][hr][quote][b]The Dixie Flatline (5/23/2012)[/b][hr]Hi Lynn.[/quote]I am not talking about he-who-is-without-clues.I am talking about someone else.[/quote]Tom Brady? He'll be retiring soon.[/quote]No, he recently said he wants to play 10 more years. If he stays healthy that seems possible. He's probably got at least 3 more years as an elite starter if he stays healthy. He also plays a more self-preserving style then Brett Favre did and he played until 40.Wed, 23 May 2012 14:16:58 GMT Jack Corbetthttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b]Lynn Pettis (5/23/2012)[/b][hr][quote][b]SQLRNNR (5/23/2012)[/b][hr][quote][b]Steve Jones - SSC Editor (5/23/2012)[/b][hr][quote][b]Stefan Krzywicki (5/23/2012)[/b][hr]Tom Brady? He'll be retiring soon.[/quote]We can only hope.[/quote]Nah - I want to see him beat down the Broncos and Peyton every chance they get.That goes with every other team in the league <> Broncos[/quote]So, is it safe to say you aren't a Broncos fan? :w00t:[/quote]Go Sanchez! (Jets fan here, but I don't watch much during the off season)Wed, 23 May 2012 14:15:59 GMTEvil Kraig Fhttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b]SQLRNNR (5/23/2012)[/b][hr][quote][b]Steve Jones - SSC Editor (5/23/2012)[/b][hr][quote][b]Stefan Krzywicki (5/23/2012)[/b][hr]Tom Brady? He'll be retiring soon.[/quote]We can only hope.[/quote]Nah - I want to see him beat down the Broncos and Peyton every chance they get.That goes with every other team in the league <> Broncos[/quote]So, is it safe to say you aren't a Broncos fan? :w00t:Wed, 23 May 2012 14:13:12 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b]Steve Jones - SSC Editor (5/23/2012)[/b][hr][quote][b]Stefan Krzywicki (5/23/2012)[/b][hr]Tom Brady? He'll be retiring soon.[/quote]We can only hope.[/quote]Nah - I want to see him beat down the Broncos and Peyton every chance they get.That goes with every other team in the league <> BroncosWed, 23 May 2012 13:58:18 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b]Stefan Krzywicki (5/23/2012)[/b][hr]Tom Brady? He'll be retiring soon.[/quote]We can only hope.Wed, 23 May 2012 13:35:11 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspxPardon me, I'd just like to vent briefly about SSRS.YOU LOUSY PIECE OF DUNG INANE INTERFACE. MS ACCESS has more ability and stronger methodology than YOU! YOU ARE TRASH.Seriously. Everything in a table. EVERYTHING. Right, because in a WYSIWIG environment having to argue your way through this control to get a damnable thing done makes SO MUCH more sense than leveraging the existing strength you had in MS Access reporting where you did it so DAMN close to right (just needed optimizations).Repeating sections, controllable repeats for sections and body, direct interface inclusions and controls. No, now everything's in a table.YOU FRACKING MORONS.... We now return you to your regularly programmed inanity.Wed, 23 May 2012 13:28:03 GMTEvil Kraig Fhttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b]Lynn Pettis (5/23/2012)[/b][hr][quote][b]The Dixie Flatline (5/23/2012)[/b][hr]Hi Lynn.[/quote]I am not talking about he-who-is-without-clues.I am talking about someone else.[/quote]Tom Brady? He'll be retiring soon.Wed, 23 May 2012 12:58:41 GMTStefan Krzywickihttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b]The Dixie Flatline (5/23/2012)[/b][hr]Hi Lynn.[/quote]I am not talking about he-who-is-without-clues.I am talking about someone else.Wed, 23 May 2012 12:46:21 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspxHi Lynn.Wed, 23 May 2012 12:28:07 GMTThe Dixie Flatlinehttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspxARRGGGGG!!!!! Why won't [i][b]he[/b][/i] just go away!Wed, 23 May 2012 11:06:40 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b]Lynn Pettis (5/23/2012)[/b][hr]Anyone else noticing a sudden concern over the size of database backup files?[/quote]I've seen a few people question it. My guess is it's a cycle, where we have some new people coming to SQL Server and asking questions.Wed, 23 May 2012 10:56:19 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspxAnyone else noticing a sudden concern over the size of database backup files?Wed, 23 May 2012 10:42:05 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b]dwain.c (5/23/2012)[/b][hr][quote][b]GilaMonster (5/23/2012)[/b][hr][quote][b]dwain.c (5/22/2012)[/b][hr][quote][b]Stefan Krzywicki (5/22/2012)[/b][hr][quote][b]Lynn Pettis (5/22/2012)[/b][hr]If people would just format their code they could figure out some of their own problems. Geez.[/quote]Many should format it all at once, like with [code="other"]Format C:\[/code][/quote]Perhaps the next time someone asks a really silly SQL question, someone will suggest this to solve their problem:[code="sql"]EXEC xp_cmdshell 'format c:\'[/code][/quote]No, because chances are someone (the OP or a later visitor) will actually try it.[/quote]Killjoy![/quote]Please, everyone knows that you can't format C: while windows is running... unless you use the /Q/X switches... Then you get a nasty surprise on restart.Wed, 23 May 2012 10:26:28 GMTvenoymhttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b]Steve Jones - SSC Editor (5/23/2012)[/b][hr]RM *[url]http://www.youtube.com/watch?v=EL_g0tyaIeE[/url][/quote]Cool!Wed, 23 May 2012 10:06:32 GMTSQL Kiwihttp://www.sqlservercentral.com/Forums/Topic604325-61-1.aspx[quote][b]GilaMonster (5/23/2012)[/b][hr][quote][b]dwain.c (5/22/2012)[/b]Perhaps the next time someone asks a really silly SQL question, someone will suggest this to solve their problem:[code="sql"]EXEC xp_cmdshell 'format c:\'[/code][/quote]No, because chances are someone (the OP or a later visitor) will actually try it.[/quote]RM *[url]http://www.youtube.com/watch?v=EL_g0tyaIeE[/url]Wed, 23 May 2012 09:28:02 GMTSteve Jones - SSC Editor