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,2574,2584,2594,2604,261»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Monday, January 13, 2014 5:28 AM


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 @ 12:20 PM
Points: 41,529, Visits: 34,445
Rodd, do you know anything about the next SQL Bits? I've asked on twitter, silence, web site hasn't been updated in ages. Was hoping to visit the UK for that.


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 #1530249
Posted Monday, January 13, 2014 5:42 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:29 AM
Points: 12,206, Visits: 9,168
GilaMonster (1/13/2014)
Rodd, do you know anything about the next SQL Bits? I've asked on twitter, silence, web site hasn't been updated in ages. Was hoping to visit the UK for that.


From the blog of Chris Webb:

I’m also still involved with SQLBits but please, please don’t ask me when the next SQLBits will be – we don’t have anything to announce yet but I can assure you we are working on it and I promise there will be one in 2014


Posted about 2 weeks ago.




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 #1530255
Posted Monday, January 13, 2014 6:05 AM


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 @ 12:20 PM
Points: 41,529, Visits: 34,445
Koen Verbeeck (1/13/2014)
GilaMonster (1/13/2014)
Rodd, do you know anything about the next SQL Bits? I've asked on twitter, silence, web site hasn't been updated in ages. Was hoping to visit the UK for that.


From the blog of Chris Webb:

I’m also still involved with SQLBits but please, please don’t ask me when the next SQLBits will be – we don’t have anything to announce yet but I can assure you we are working on it and I promise there will be one in 2014


Posted about 2 weeks ago.


Cool, thanks. Am hoping it's middle of the year, late will conflict with PASS.



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 #1530259
Posted Monday, January 13, 2014 8:38 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 11:06 AM
Points: 2,847, Visits: 4,836
GilaMonster (1/13/2014)
Koen Verbeeck (1/13/2014)
GilaMonster (1/13/2014)
Rodd, do you know anything about the next SQL Bits? I've asked on twitter, silence, web site hasn't been updated in ages. Was hoping to visit the UK for that.


From the blog of Chris Webb:

I’m also still involved with SQLBits but please, please don’t ask me when the next SQLBits will be – we don’t have anything to announce yet but I can assure you we are working on it and I promise there will be one in 2014


Posted about 2 weeks ago.


Cool, thanks. Am hoping it's middle of the year, late will conflict with PASS.


Both,

It's very frustrating here as well. Anyone who does know anything is keeping tight lipped. Last Years was May 4. So it still could be around then give or take a few weeks - hope I'm not in Chicago. :O

I don't think the committee want to run two a year any more so it should be first half of the year - as you say otherwise it could end up too close to the Summit and the European Rally (s)

Tim said via twitter in November they had an interesting venue in mind and were trying to sort out contracts. No idea if the silence means this has fallen through. Also someone did ask one of the committee about the location, I believe "North of Watford" was odds on favourite.

My feeling is we will know before the end of the month so long as there hasn't been any issues with contracts.

Sorry can't be of much help otherwise :-(

Rodders...



Post #1530318
Posted Monday, January 13, 2014 8:44 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 11:06 AM
Points: 2,847, Visits: 4,836
You have got to love where I work at the moment.
Colleague went to French office last week, and today can't seem to connect to anything. Wondered if config changes on laptop or firewall rules now thought his machine was French... But no network team re-patched his network cable last week not realising it was his desk.
They have asked for a call to be logged so they can assign time to fix the issue. So sorry we can't do it right now even though it was us who caused it.

Last week had a problem with a job, I fixed the issue but had to wait until the job ran next time to make sure it had really fixed the issue (test server anyone), so service desk closed the call - I, erm, politely asked them to re-open it as we hadn't actually seen it work yet.

Rodders...



Post #1530323
Posted Monday, January 13, 2014 9:16 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 10:15 AM
Points: 32,779, Visits: 14,938
I'm hoping to get back to SQLBits this year, but with surgery coming, timing will matter. I hope they announce something soon.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1530345
Posted Tuesday, January 14, 2014 7:26 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:36 PM
Points: 11,985, Visits: 11,005
Here is a true story from the field that a buddy of mine shared with me yesterday.


Yesterday my supervisor sent me an email regarding a view that wasn't returning accurate info to the users and he wanted me to look at it. Unfortunately I was unable to last night as I was busy with another priority that took all night.

The view uses a lot of subqueries in the select list, many of them from the same tables, and used group by with select top 1. Needless to say these subqueries could (and was) pulling data from different records with the same parent key. I wonder why the information was inconsistent.

Well, my supervisor decided to try and tackle the problem and rewrite the view. He moved the subqueries to left outer joins in the FROM clause but was not working very well. He didn't have time to use the DTA to help tune the indexes to help improve his query, so when I got in he turned it back over to me.

After about an hour, I had consolidated the multiple individual subqueries into three subqueries using outer apply in the FROM clause. The original view with inaccurate data ran in about 33 seconds. My rewrite runs in 6 seconds, and I am sure I could come up with a few covering indexes on the subtables that would increase the performance more. Both versions return about 56,000 rows of data. My boss’s, well I stopped it after 2 hours and 16 minutes and it had only returned a little over 20,000 rows.

Goes to show that you should leave rewriting SQL to the professionals.


_______________________________________________________________

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 #1530673
Posted Tuesday, January 14, 2014 8:40 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 10:15 AM
Points: 32,779, Visits: 14,938
Sean Lange (1/14/2014)
Here is a true story from the field that a buddy of mine shared with me yesterday.

[quote]
Goes to show that you should leave rewriting SQL to the professionals.
[/code]


Or teach others to be more professional.

How about an article from your buddy on the process for the code? That's how people learn.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1530726
Posted Tuesday, January 14, 2014 9:05 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:36 PM
Points: 11,985, Visits: 11,005
Steve Jones - SSC Editor (1/14/2014)
Sean Lange (1/14/2014)
Here is a true story from the field that a buddy of mine shared with me yesterday.

[quote]
Goes to show that you should leave rewriting SQL to the professionals.
[/code]


Or teach others to be more professional.

How about an article from your buddy on the process for the code? That's how people learn.


I can't say I disagree with your sentiment there Steve. That was all copy-paste from me. My guess there are some other levels of politics and BS involved. I know this guy pretty well and I know that if there is the opportunity to teach he will take that road. Of course all know that isn't always the case because sometime the student doesn't want to learn.


_______________________________________________________________

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 #1530737
Posted Tuesday, January 14, 2014 10:54 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:33 PM
Points: 14,800, Visits: 27,274
Sean Lange (1/14/2014)
Here is a true story from the field that a buddy of mine shared with me yesterday.


Yesterday my supervisor sent me an email regarding a view that wasn't returning accurate info to the users and he wanted me to look at it. Unfortunately I was unable to last night as I was busy with another priority that took all night.

The view uses a lot of subqueries in the select list, many of them from the same tables, and used group by with select top 1. Needless to say these subqueries could (and was) pulling data from different records with the same parent key. I wonder why the information was inconsistent.

Well, my supervisor decided to try and tackle the problem and rewrite the view. He moved the subqueries to left outer joins in the FROM clause but was not working very well. He didn't have time to use the DTA to help tune the indexes to help improve his query, so when I got in he turned it back over to me.

After about an hour, I had consolidated the multiple individual subqueries into three subqueries using outer apply in the FROM clause. The original view with inaccurate data ran in about 33 seconds. My rewrite runs in 6 seconds, and I am sure I could come up with a few covering indexes on the subtables that would increase the performance more. Both versions return about 56,000 rows of data. My boss’s, well I stopped it after 2 hours and 16 minutes and it had only returned a little over 20,000 rows.

Goes to show that you should leave rewriting SQL to the professionals.


DTA!!!!!!

Burn it with fire!!!


----------------------------------------------------
"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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1530788
« Prev Topic | Next Topic »

Add to briefcase «««4,2574,2584,2594,2604,261»»»

Permissions Expand / Collapse