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,1264,1274,1284,1294,130»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Thursday, September 12, 2013 6:10 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 5:45 PM
Points: 3,617, Visits: 5,237
Jack Corbett (9/12/2013)
Brandie Tarvin (9/12/2013)
Ed,

Go to www.sqlsaturday.com and see if there is a way to register for event notifications. That way if one pops up near you again, you can see the notification before instead of after the event.


From my experience the best way to find out about new events is to speak at one I get email notifications for every SQLSaturday.

Being on Twitter and LinkedIn (join the tech groups). I know I promote SQLSaturday's I organize on both.


How does one go about organizing a SQL Saturday?

Anybody up for joining one in Bangkok?



My mantra: No loops! No CURSORs! No RBAR! Hoo-uh!

My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.


Need to UNPIVOT? Why not CROSS APPLY VALUES instead?
Since random numbers are too important to be left to chance, let's generate some!
Learn to understand recursive CTEs by example.
Splitting strings based on patterns can be fast!
Post #1494407
Posted Thursday, September 12, 2013 6:15 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 6:45 PM
Points: 21,351, Visits: 15,030
dwain.c (9/12/2013)
Jack Corbett (9/12/2013)
Brandie Tarvin (9/12/2013)
Ed,

Go to www.sqlsaturday.com and see if there is a way to register for event notifications. That way if one pops up near you again, you can see the notification before instead of after the event.


From my experience the best way to find out about new events is to speak at one I get email notifications for every SQLSaturday.

Being on Twitter and LinkedIn (join the tech groups). I know I promote SQLSaturday's I organize on both.


How does one go about organizing a SQL Saturday?

Anybody up for joining one in Bangkok?


One Night in Bangkok? Sounds fun




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 #1494408
Posted Thursday, September 12, 2013 9:47 PM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, July 3, 2014 9:19 PM
Points: 605, Visits: 1,691
bitbucket-25253 (9/10/2013)
Ed Wagner (9/10/2013)
SQLRNNR (9/10/2013)
[quote]Brandie Tarvin (9/10/2013)
I am seriously thinking of making DBCC Timewarp settings one of my own interview questions, just to see how far the SQL Conspiracy has spread.


What are 3 of the required parameters for DBCC Timewarp?

What are 7 of the optional parameters?


I like where this is headed.


Ah come now we all know that DBCC Timewarp has 137 required parameters and 256 optional parameters.



Didn't DBCC Timewarp get deprecated and removed from a previous version of SQL Server before it was released?



Fal.


Post #1494432
Posted Friday, September 13, 2013 12:32 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:26 AM
Points: 13,359, Visits: 10,223
Fal (9/12/2013)

Didn't DBCC Timewarp get deprecated and removed from a previous version of SQL Server before it was released?


That's what they want you to believe.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1494458
Posted Friday, September 13, 2013 1:12 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:56 AM
Points: 7,137, Visits: 13,527
dwain.c (9/12/2013)
Jack Corbett (9/12/2013)
Brandie Tarvin (9/12/2013)
Ed,

Go to www.sqlsaturday.com and see if there is a way to register for event notifications. That way if one pops up near you again, you can see the notification before instead of after the event.


From my experience the best way to find out about new events is to speak at one I get email notifications for every SQLSaturday.

Being on Twitter and LinkedIn (join the tech groups). I know I promote SQLSaturday's I organize on both.


How does one go about organizing a SQL Saturday?

Anybody up for joining one in Bangkok?

I wonder if a UK contractor could declare this as a business expense?


“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 #1494485
Posted Friday, September 13, 2013 1:25 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 5:45 PM
Points: 3,617, Visits: 5,237
ChrisM@Work (9/13/2013)
dwain.c (9/12/2013)
Jack Corbett (9/12/2013)
Brandie Tarvin (9/12/2013)
Ed,

Go to www.sqlsaturday.com and see if there is a way to register for event notifications. That way if one pops up near you again, you can see the notification before instead of after the event.


From my experience the best way to find out about new events is to speak at one I get email notifications for every SQLSaturday.

Being on Twitter and LinkedIn (join the tech groups). I know I promote SQLSaturday's I organize on both.


How does one go about organizing a SQL Saturday?

Anybody up for joining one in Bangkok?

I wonder if a UK contractor could declare this as a business expense?


I don't know the UK tax laws but if sufficient interest is generated and enough big names sign up, I'd hope Her Majesty's taxman would acquiesce.



My mantra: No loops! No CURSORs! No RBAR! Hoo-uh!

My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.


Need to UNPIVOT? Why not CROSS APPLY VALUES instead?
Since random numbers are too important to be left to chance, let's generate some!
Learn to understand recursive CTEs by example.
Splitting strings based on patterns can be fast!
Post #1494488
Posted Friday, September 13, 2013 4:31 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:24 AM
Points: 7,133, Visits: 6,295
dwain.c (9/12/2013)
[quote]How does one go about organizing a SQL Saturday?

Anybody up for joining one in Bangkok?


I would coordinate through PASS. And contact Karla Landrum (@KarlaKay22 on Twitter). She's a SQL Evanglist with PASS and helps people set up SQL Saturday events.


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1494531
Posted Friday, September 13, 2013 9:54 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 3:21 PM
Points: 1,210, Visits: 2,512
SQLRNNR (9/10/2013)
Brandie Tarvin (9/10/2013)
I am seriously thinking of making DBCC Timewarp settings one of my own interview questions, just to see how far the SQL Conspiracy has spread.


What are 3 of the required parameters for DBCC Timewarp?

What are 7 of the optional parameters?


I like where this is headed.


"Describe the relativistic behavior of DBCC Timewarp when optional parameter @bigG is set to a value other than the default gravitational constant (6.674x10-11N(m/kg)2)."


Jason Wolfkill
Blog: SQLSouth
Twitter: @SQLSouth
Post #1494638
Posted Friday, September 13, 2013 10:50 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, July 24, 2014 9:07 AM
Points: 11,157, Visits: 12,899
dwain.c (9/12/2013)
Jack Corbett (9/12/2013)
Brandie Tarvin (9/12/2013)
Ed,

Go to www.sqlsaturday.com and see if there is a way to register for event notifications. That way if one pops up near you again, you can see the notification before instead of after the event.


From my experience the best way to find out about new events is to speak at one I get email notifications for every SQLSaturday.

Being on Twitter and LinkedIn (join the tech groups). I know I promote SQLSaturday's I organize on both.


How does one go about organizing a SQL Saturday?

Anybody up for joining one in Bangkok?


You start here. Karla is really good at walking you through the first one. Then you ask questions in places like this because some of us have organized at least one.




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1494668
Posted Monday, September 16, 2013 5:41 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 12:32 PM
Points: 961, Visits: 5,000
What happened? Nothing new in here all weekend, and it's not even any sort of a holiday anywhere (that I'm aware of at least...)

Just think everyone!
Only 101 more shopping days until X-Mas!


(ducks behind fresh built snow fort. And people *LAUGHED* when I bought a snow making machine!)
Post #1495016
« Prev Topic | Next Topic »

Add to briefcase «««4,1264,1274,1284,1294,130»»»

Permissions Expand / Collapse