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,9153,9163,9173,9183,919»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Friday, March 15, 2013 12:18 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 3:59 PM
Points: 13,007, Visits: 12,426
L' Eomot Inversé (3/15/2013)
SQLRNNR (3/15/2013)
Lynn Pettis (3/15/2013)
Stefan Krzywicki (3/15/2013)
SQLRNNR (3/15/2013)
This thread is now at 39,153 posts. Do we start the countdown now to 40,000?


Isn't 39,153 to 40,000 a count up?


Naw, wait until we are closer and then we start the "99 bottles of beer" routine.


The wheels on the bus have started rolling round n round. We can't stop it now.

But we'd need more than 70 cases of beer to count it properly.


I'm willing to do my part.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1431671
Posted Friday, March 15, 2013 12:26 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 7:58 PM
Points: 20,705, Visits: 32,356
I'm guessing I overstepped the line again.



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 #1431674
Posted Friday, March 15, 2013 1:15 PM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, September 26, 2014 1:39 PM
Points: 670, Visits: 6,720
Steve Jones - SSC Editor (3/15/2013)
jasona.work (3/15/2013)
842 bottles of beer on the wall!
842 bottles of beer!


I want one.


Me too!
Or I am thirsty, me two!
I just got confused and lost count again.
Post #1431707
Posted Friday, March 15, 2013 1:27 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:57 PM
Points: 7,745, Visits: 9,493
Greg Edwards-268690 (3/15/2013)
Steve Jones - SSC Editor (3/15/2013)
jasona.work (3/15/2013)
842 bottles of beer on the wall!
842 bottles of beer!


I want one.


Me too!
Or I am thirsty, me two!
I just got confused and lost count again.

Me three!
I think you were T-837, but the seductive fluid may have had a pernicious influence on my counting.


Tom
Post #1431711
Posted Friday, March 15, 2013 1:39 PM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Yesterday @ 1:14 PM
Points: 39,977, Visits: 36,340
I think someone is several miles out of his depth here...
http://www.sqlservercentral.com/Forums/Topic1430383-2799-1.aspx

p.s. I know he needs to partition by date, not region. Trying to get him to realise that as well by asking if he's archiving and deleting entire regions.



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 #1431723
Posted Friday, March 15, 2013 1:54 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 7:58 PM
Points: 20,705, Visits: 32,356
GilaMonster (3/15/2013)
I think someone is several miles out of his depth here...
http://www.sqlservercentral.com/Forums/Topic1430383-2799-1.aspx


Quite so. I don't think I'll even venture there for more than a peek now and then.



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 #1431728
Posted Friday, March 15, 2013 2:15 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 7:58 PM
Points: 20,705, Visits: 32,356
Alrighty now. now I am a troll.



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 #1431742
Posted Friday, March 15, 2013 3:01 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 7:58 PM
Points: 20,705, Visits: 32,356
I am really trying not say anything more over ther, but is really difficult. Group time at the TitD.

Hi, My name is Lynn and I am a troll, and not a cute one at that.




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 #1431773
Posted Friday, March 15, 2013 3:10 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 7:58 PM
Points: 20,705, Visits: 32,356
Lynn Pettis (3/15/2013)
I am really trying not say anything more over ther, but is really difficult. Group time at the TitD.

Hi, My name is Lynn and I am a troll, and not a cute one at that.



Sorry group, but I was forced to speak up again. I really don't like being called a her or she when I am a him or he.



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 #1431782
Posted Friday, March 15, 2013 4:53 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 9:28 PM
Points: 17,729, Visits: 15,597
Lynn Pettis (3/15/2013)
Lynn Pettis (3/15/2013)
I am really trying not say anything more over ther, but is really difficult. Group time at the TitD.

Hi, My name is Lynn and I am a troll, and not a cute one at that.



Sorry group, but I was forced to speak up again. I really don't like being called a her or she when I am a him or he.


Whatever you cutey




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

Add to briefcase «««3,9153,9163,9173,9183,919»»»

Permissions Expand / Collapse