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 «««4,1204,1214,1224,1234,124»»»

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


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 6:37 PM
Points: 33,189, Visits: 15,329
Jeff Moden (9/5/2013)
Steve Jones - SSC Editor (9/5/2013)
http://www.liveleak.com/view?i=424_1378224156


Let's stick Jeff in this interview ;)


BWAAA-HAAAA!!!! Don't forget... I take porkchops to interviews, as well. And I don't just get even, I get ahead. Someone would look real funny with that TV sticking out of their saddle-padding and a car full of quick drying cement.


Be worth capturing the look on your face.

Interest? Fascination? Terror? Zzzzzzzzz?







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1492252
Posted Friday, September 6, 2013 8:28 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 1:37 PM
Points: 21,639, Visits: 15,309
Steve Jones - SSC Editor (9/6/2013)
Jeff Moden (9/5/2013)
Steve Jones - SSC Editor (9/5/2013)
http://www.liveleak.com/view?i=424_1378224156


Let's stick Jeff in this interview ;)


BWAAA-HAAAA!!!! Don't forget... I take porkchops to interviews, as well. And I don't just get even, I get ahead. Someone would look real funny with that TV sticking out of their saddle-padding and a car full of quick drying cement.


Be worth capturing the look on your face.

Interest? Fascination? Terror? Zzzzzzzzz?


Hard to tell with that beard




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1492275
Posted Friday, September 6, 2013 9:22 AM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 7:34 PM
Points: 36,978, Visits: 31,498
SQLRNNR (9/6/2013)
Steve Jones - SSC Editor (9/6/2013)
Jeff Moden (9/5/2013)
Steve Jones - SSC Editor (9/5/2013)
http://www.liveleak.com/view?i=424_1378224156


Let's stick Jeff in this interview ;)


BWAAA-HAAAA!!!! Don't forget... I take porkchops to interviews, as well. And I don't just get even, I get ahead. Someone would look real funny with that TV sticking out of their saddle-padding and a car full of quick drying cement.


Be worth capturing the look on your face.

Interest? Fascination? Terror? Zzzzzzzzz?


Hard to tell with that beard


Since they turn out the lights, I'd take the opportunity for a quick nap while waiting for the cement truck to arrive. I always need a nap after working to make a large TV fit into someones saddle-padding.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1492299
Posted Saturday, September 7, 2013 4:35 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 3:06 PM
Points: 23,276, Visits: 31,996
I have a weird situation here.

Any thoughts or suggestions would be welcome.




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 #1492496
Posted Saturday, September 7, 2013 8:56 AM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 3:06 PM
Points: 23,276, Visits: 31,996
Lynn Pettis (9/7/2013)
I have a weird situation here.

Any thoughts or suggestions would be welcome.



Solved my problem. Turns out the two tables weren't 100% structurally the same. One of them had a d*** trigger on it. I'll worry about the trigger later, but we know what needs to be done in the future at least.



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 #1492534
Posted Saturday, September 7, 2013 12:17 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 4:58 AM
Points: 2,467, Visits: 6,437
SQL Saturday in Cape Town today was awesome. Took a whole lot of new knowledge away from it. And, as to be expected, Gail's presentation on "Do's and Don'ts of Database Corruption" was top of the cream. Thanks, Gail! Hope you'll be back next year

--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)

In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)
Post #1492544
Posted Saturday, September 7, 2013 12:39 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 @ 3:07 PM
Points: 42,812, Visits: 35,931
Jan Van der Eecken (9/7/2013)
And, as to be expected, Gail's presentation on "Do's and Don'ts of Database Corruption" was top of the cream. Thanks, Gail!


You're welcome.

And now, as a reward, all the forum's corruption questions are belong to you.



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 #1492546
Posted Saturday, September 7, 2013 12:56 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 4:58 AM
Points: 2,467, Visits: 6,437
GilaMonster (9/7/2013)
Jan Van der Eecken (9/7/2013)
And, as to be expected, Gail's presentation on "Do's and Don'ts of Database Corruption" was top of the cream. Thanks, Gail!


You're welcome.

And now, as a reward, all the forum's corruption questions are belong to you.


Check my signature


--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)

In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)
Post #1492547
Posted Saturday, September 7, 2013 2:07 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 4:58 AM
Points: 2,467, Visits: 6,437
GilaMonster (9/7/2013)
Jan Van der Eecken (9/7/2013)
And, as to be expected, Gail's presentation on "Do's and Don'ts of Database Corruption" was top of the cream. Thanks, Gail!


You're welcome.

And now, as a reward, all the forum's corruption questions are belong to you.


BTW, I sent you a PM with one of the pics you took using my phone attached.

Ed: Sounded like you pinched my phone...


--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)

In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)
Post #1492551
Posted Saturday, September 7, 2013 3:29 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 4:58 AM
Points: 2,467, Visits: 6,437
Jan Van der Eecken (9/3/2013)
SQLRNNR (9/2/2013)
Koen Verbeeck (9/1/2013)
GilaMonster (8/31/2013)
Just ....

Microsoft will no longer offer Masters and Architect level training rotations and will be retiring the Masters level certification exams as of October 1, 2013.


Sent late on a Friday night, right before a USA long weekend.

At least I no longer have to worry about budgeting for the upgrade exam.


That's just sad.


For those that haven't seen it yet

Connect Item on the Retirement of MCM
https://connect.microsoft.com/SQLServer/feedback/details/799431/please-dont-get-rid-of-the-mcm-and-mca-programs

And a lengthy summary of the whole thing
http://jasonbrimhall.info/2013/09/02/rare-species-extinction-and-the-mcm/


Tried to vote for it, but then I get

"The system has encountered an unexpected error. We apologize for the inconvenience. The issue will be addressed as quickly as possible."


And now I get a "Page Not Found" error instead?


--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)

In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)
Post #1492558
« Prev Topic | Next Topic »

Add to briefcase «««4,1204,1214,1224,1234,124»»»

Permissions Expand / Collapse