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,5404,5414,5424,5434,544»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Tuesday, September 2, 2014 3:13 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 4:24 PM
Points: 20,739, Visits: 32,526
AARRRGGGGGGG!!!!!!!!!!! Someone fire the man. He has no business in this business.



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 #1609819
Posted Tuesday, September 2, 2014 3:16 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:37 PM
Points: 2,228, Visits: 6,031
Lynn Pettis (9/2/2014)
AARRRGGGGGGG!!!!!!!!!!! Someone fire the man. He has no business in this business.


Think that here is a proper use for a TERMINATOR
Post #1609821
Posted Tuesday, September 2, 2014 3:17 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Today @ 4:24 PM
Points: 20,739, Visits: 32,526
Time to walk away from another one. Sandbox, all I want is a sandbox.....



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 #1609823
Posted Tuesday, September 2, 2014 3:41 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 1:04 PM
Points: 13,086, Visits: 12,553
Lynn Pettis (9/2/2014)
AARRRGGGGGGG!!!!!!!!!!! Someone fire the man. He has no business in this business.


In my experience nearly 95% of the people in this business actually have the brains to be in this business. Then there are about 4% of those with enough brains that don't have a "give a damn" to learn anything new. That leaves about 1% that have enough drive and brains to actually improve over time. Sadly the other 99% are the ones taking jobs and giving a bad name to the rest of us. You have to make a choice when you run across people like that. Either help them and try not to pop your own eyeballs or see their name as the OP and walk away. There have been many threads over the years were I could have helped that person but because I knew they wouldn't understand it anyway I just walked away. You should try it, it is quite liberating.


_______________________________________________________________

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 #1609831
Posted Tuesday, September 2, 2014 5:54 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:45 AM
Points: 7,804, Visits: 9,556
Lynn Pettis (9/2/2014)
Am I missing something? Doesn't this error mean that the table or view doesn't exist, not that there is a problem with the WHERE clause?

OLE DB provider "MSDASQL" for linked server "LS_RDB_DWH_POLICY52" returned message "[Oracle][ODBC][Ora]ORA-00942: table or view does not exist".


Well, if the where clause contains a subquery which refers to a table not mentioned elsewhere in the query, the problem in the where clause could be that it refers to a non-existent table.

T-SQL is pretty flexible about allowing such subqueries; it's 20 years since I last touched PL-SQL (in Oracle 6, I think) so I'm certainly not going to look at the problem that comment came from, but I think the same probably applies there, too. I suspect that SQL Server would deliver a more useful error message. Perhaps Oracle wouldn't.


Tom
Post #1609850
Posted Tuesday, September 2, 2014 6:07 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:45 AM
Points: 7,804, Visits: 9,556
Sean Lange (9/2/2014)
Lynn Pettis (9/2/2014)
AARRRGGGGGGG!!!!!!!!!!! Someone fire the man. He has no business in this business.


In my experience nearly 95% of the people in this business actually have the brains to be in this business. Then there are about 4% of those with enough brains that don't have a "give a damn" to learn anything new. That leaves about 1% that have enough drive and brains to actually improve over time.

I'm confused. You mean 96% or 95% is just 1%???? Not when I was in primary school it wasn't, and that's not the sort of thing that changes over he years (not even over that many years). Maybe there's a bigger language barrier between my English and your English that I thought there was?

Regardless of that, though, I think we both agree with Lynn on the unemployability of the man who couldn't imagine a set-based solution.


Tom
Post #1609854
Posted Tuesday, September 2, 2014 6:11 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: Today @ 5:24 PM
Points: 3,784, Visits: 8,489
TomThomson (9/2/2014)
Sean Lange (9/2/2014)
Lynn Pettis (9/2/2014)
AARRRGGGGGGG!!!!!!!!!!! Someone fire the man. He has no business in this business.


In my experience nearly 95% of the people in this business actually don't have the brains to be in this business. Then there are about 4% of those with enough brains that don't have a "give a damn" to learn anything new. That leaves about 1% that have enough drive and brains to actually improve over time.

I'm confused. You mean 96% or 95% is just 1%???? Not when I was in primary school it wasn't, and that's not the sort of thing that changes over he years (not even over that many years). Maybe there's a bigger language barrier between my English and your English that I thought there was?

Regardless of that, though, I think we both agree with Lynn on the unemployability of the man who couldn't imagine a set-based solution.

I guess there's a word missing. That will give 95 + 4 + 1 = 100



Luis C.
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1609855
Posted Tuesday, September 2, 2014 6:27 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
GilaMonster (9/2/2014)
"The inserted table only contains the rows inserted into the table. I need rows from other tables as well. Hence I can't use a set-based solution"

Err.. ok...


Bwahaha! Second funniest thing I've heard this morning.

Here's the first: http://www.red-gate.com/products/dba/sql-monitor/entrypage/worst-dba-days-4/?utm_source=emailmarketing&utm_medium=email&utm_campaign=sqldbabundle&utm_content=day-4&utm_term=E304&_hsenc=p2ANqtz--RZ6K_2-01B2TN2vRLpbTV45ULOnFZ0RTzwnEeEgK0BCeJ4RIQHnMjomI8n5q6RfNI2FjphkScx_laQht1vhqYMbUOHQ&_hsmi=13982098

My (cowboy) hat's off to Steve and Grant for this hilarious and oddly illuminating parody.



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 #1609857
Posted Wednesday, September 3, 2014 6:37 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, October 20, 2014 11:55 AM
Points: 1,330, Visits: 19,306
dwain.c (9/2/2014)
GilaMonster (9/2/2014)
"The inserted table only contains the rows inserted into the table. I need rows from other tables as well. Hence I can't use a set-based solution"

Err.. ok...


Bwahaha! Second funniest thing I've heard this morning.

Here's the first: http://www.red-gate.com/products/dba/sql-monitor/entrypage/worst-dba-days-4/?utm_source=emailmarketing&utm_medium=email&utm_campaign=sqldbabundle&utm_content=day-4&utm_term=E304&_hsenc=p2ANqtz--RZ6K_2-01B2TN2vRLpbTV45ULOnFZ0RTzwnEeEgK0BCeJ4RIQHnMjomI8n5q6RfNI2FjphkScx_laQht1vhqYMbUOHQ&_hsmi=13982098

My (cowboy) hat's off to Steve and Grant for this hilarious and oddly illuminating parody.
Favorite line:
"Oh, shut the functional dependency up, Chris. Don't you ever give up?"


My wife keeps telling me I need to stop swearing around the two year old. I'm going to replace swearing with database jargon randomness now...

Flaming Firehose Cursors!
Backwards Compatibility!
Great Moden's Socks!


---------------------------------------------------------
How best to post your question
How to post performance problems
Tally Table:What it is and how it replaces a loop

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
Post #1609989
Posted Wednesday, September 3, 2014 6:45 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:01 AM
Points: 6,954, Visits: 7,077
jcrawf02 (9/3/2014)
[quote]My wife keeps telling me I need to stop swearing around the two year old. I'm going to replace swearing with database jargon randomness now...

Flaming Firehose Cursors!
Backwards Compatibility!
Great Moden's Socks!


Surely you mean
Moden's Beard!



Far away is close at hand in the images of elsewhere.

Anon.

Post #1609992
« Prev Topic | Next Topic »

Add to briefcase «««4,5404,5414,5424,5434,544»»»

Permissions Expand / Collapse