Viewing 15 posts - 511 through 525 (of 1,189 total)
akhamoshioke (6/3/2014)
Please do and post your feedback on the flaws with it and possible fixes so i can keep improving it.
Thanks for this script!
It works great on SQL Server 2008...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
June 20, 2014 at 12:58 pm
Koen Verbeeck (6/18/2014)
The answer is incorrect.The question clearly states that the databases are on site. Thus, by the process of elimination, the corruption answer is the only one left.
Good point....
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
June 18, 2014 at 9:20 am
Thanks, Jeff, for this great article.
I have one small editorial comment.
In the section Filtering for "2" Products, the query is the one below:
--===== Find Customers that bought either "A" OR...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
June 16, 2014 at 8:50 pm
Thanks for this editorial. You know, it's funny. A lot of things that I used to see as grumpy in DBAs or in other IT people is actually a lot...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
June 10, 2014 at 10:15 am
SQLDCH (6/4/2014)
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
June 5, 2014 at 11:59 am
Thanks to everyone for their replies!
Yes, I am restoring using the same version of SQL Server, just on a different server.
I will take some time to go through the...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
June 5, 2014 at 9:25 am
TheSQLGuru (5/28/2014)
SQLRNNR (5/28/2014)
Another vote for the RedGate SQL Compare tools.Nice license plate Jason S.
Another vote for Red-Gate SQL Compare. There are a number of other options from third parties...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
May 30, 2014 at 11:52 am
Mighty (5/26/2014)
Not really happy with the wording of the answers.I left the first option out, because the second option seemed "supersede" the first option.
I feel the same way.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
May 30, 2014 at 11:48 am
Thank you, Erin! Pretty impressive article. I look forward to using the scripts as soon as possible.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
May 28, 2014 at 11:43 am
I think this is the most complete etymological explanation:
That kind of table comes from the Latin tabula meaning "a board or plank" which was used for writing down columns of...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
May 24, 2014 at 6:32 pm
Andy Warren (5/19/2014)
Comments posted to this topic are about the item <A HREF="/questions/foreign+keys/109289/">Running Out Of Foreign Keys</A>
Thanks - great question. I got it wrong, so back to the books!
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
May 23, 2014 at 2:34 pm
LutzM (5/18/2014)
Would you mind sharing the reason and how you resolved it?It might help others running into the same issue...
Yes, I agree. It would help a lot to post the...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
May 21, 2014 at 1:38 pm
Lynn Pettis (5/21/2014)
webrunner (5/21/2014)
...
Thank you for your response, Jeff!
Yes, I am working on a test server. I just want to be confident that when I submit all these changes to...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
May 21, 2014 at 11:47 am
Jeff Moden (5/20/2014)
webrunner (5/20/2014)
I'm working on an upgrade to SQL Server 2012. One of the things that came up is that the text, ntext, and image are being deprecated....
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
May 21, 2014 at 8:26 am
aajavaherian (5/5/2014)
If Linda changes her name, couldn't you just query her name and update the table with an update statement?
As others have said, that involves updating many rows when, with...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
May 7, 2014 at 9:45 am
Viewing 15 posts - 511 through 525 (of 1,189 total)