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,9003,9013,9023,9033,904»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Monday, February 25, 2013 3:52 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 10:58 AM
Points: 5,333, Visits: 25,272
L' Eomot Inversé (2/25/2013)
No QotD yet today? Has everyone stopped submitting them?


Was wondering was it my link that failed to show the current QOD, so your note relieved me of that anxiety.

Spent a good hour having my home computer check for bugs / malware ... oh well


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1423806
Posted Monday, February 25, 2013 4:18 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 9:59 AM
Points: 17,822, Visits: 15,747
bitbucket-25253 (2/25/2013)
L' Eomot Inversé (2/25/2013)
No QotD yet today? Has everyone stopped submitting them?


Was wondering was it my link that failed to show the current QOD, so your note relieved me of that anxiety.

Spent a good hour having my home computer check for bugs / malware ... oh well


And no newsletter for me today.




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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1423811
Posted Monday, February 25, 2013 5:22 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 10:58 AM
Points: 5,333, Visits: 25,272
bitbucket-25253 (2/25/2013)
L' Eomot Inversé (2/25/2013)
No QotD yet today? Has everyone stopped submitting them?


Was wondering was it my link that failed to show the current QOD, so your note relieved me of that anxiety.

Spent a good hour having my home computer check for bugs / malware ... oh well


CHANGE CHANGE
Received an E-Mail notification (7:02 PM) that 2 additional QOTD submission of mine had been scheduled, Feb 27th and March 4th


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1423828
Posted Tuesday, February 26, 2013 4:39 PM


SSC-Dedicated

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

Group: Administrators
Last Login: Yesterday @ 12:34 PM
Points: 31,181, Visits: 15,626
L' Eomot Inversé (2/25/2013)
No QotD yet today? Has everyone stopped submitting them?


My fault. Frazzled from a week in Seattle and a bunch of deadlines on my plate. Since I usually schedule out a month or two at a time, got caught here.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1424282
Posted Tuesday, February 26, 2013 11:49 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: Tuesday, October 7, 2014 10:53 PM
Points: 3,421, Visits: 5,359
Sean Lange (2/25/2013)
Another crazy snowstorm in Kansas City. This is the second thunder snow in 5 days. It is really quite odd to hear rolling thunder while it is blizzarding. We got a little over 12" on Thursday and they are predicting anywhere from 12 - 20" overnight and through tomorrow. Yet another forced vacation day tomorrow. See you all in a couple days once we dig out again.


Snow? Blizzard? What are those?

Bangkok=HOT!



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 #1424352
Posted Wednesday, February 27, 2013 6:29 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:53 AM
Points: 13,890, Visits: 28,285
I've got a poster over at AskSSC that is utterly confusing me. He's either very unclear, or I'm very obtuse or some combination of the two. If anyone with an account over there can please take a look at this, I'd appreciate it. But please, let's just be helpful, not critical.

----------------------------------------------------
"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 Query Performance Tuning
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 #1424494
Posted Wednesday, February 27, 2013 9:44 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Yesterday @ 12:34 PM
Points: 31,181, Visits: 15,626
About 2-4" of snow last night, but blowing hard. I have 2-3 ft sandbars in the driveway.

School cancelled.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1424618
Posted Wednesday, February 27, 2013 10:06 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:17 AM
Points: 13,085, Visits: 12,549
Steve Jones - SSC Editor (2/27/2013)
About 2-4" of snow last night, but blowing hard. I have 2-3 ft sandbars in the driveway.

School cancelled.


I feel your pain Steve. We have been getting snow here more like what you are used to in Colorado. We have had close to 2 feet in the last 6 days. School is cancelled yet again today. Our office even closed for a couple of days. I hope the storm you had last night does not hit us.

The snow piles in the driveway yesterday were almost 4 feet high thanks to the snowplows keeping the streets clear.


_______________________________________________________________

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 #1424631
Posted Wednesday, February 27, 2013 12:31 PM
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 @ 9:15 AM
Points: 840, Visits: 7,375
Sean Lange (2/27/2013)
Steve Jones - SSC Editor (2/27/2013)
About 2-4" of snow last night, but blowing hard. I have 2-3 ft sandbars in the driveway.

School cancelled.


I feel your pain Steve. We have been getting snow here more like what you are used to in Colorado. We have had close to 2 feet in the last 6 days. School is cancelled yet again today. Our office even closed for a couple of days. I hope the storm you had last night does not hit us.

The snow piles in the driveway yesterday were almost 4 feet high thanks to the snowplows keeping the streets clear.


I haven't done anything with CLR in a few years. Now I need to create JSON files and CLR looks like the best way. Anyone have a link to a good CLR tutorial site? Or should i be buying a book?


--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
Post #1424689
Posted Wednesday, February 27, 2013 2:16 PM


SSC-Dedicated

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

Group: Administrators
Last Login: Yesterday @ 12:34 PM
Points: 31,181, Visits: 15,626
Stefan Krzywicki (2/27/2013)


I haven't done anything with CLR in a few years. Now I need to create JSON files and CLR looks like the best way. Anyone have a link to a good CLR tutorial site? Or should i be buying a book?


Haven't seen a lot on it. I know Adam Machanic and a few people use it, but don't see much written.

I did run across this: http://www.olcot.co.uk/sql-blogs/creating-cards-in-trello-via-the-rest-api-by-using-a-sql-clr







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1424745
« Prev Topic | Next Topic »

Add to briefcase «««3,9003,9013,9023,9033,904»»»

Permissions Expand / Collapse