Viewing 15 posts - 991 through 1,005 (of 1,189 total)
Great article, thanks. I especially like the reminder to build and use databases for practice (music catalog, recipes, etc.) - I don't do enough of that experimentation, but it is...
-------------------
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
December 20, 2007 at 7:54 am
An example of this problem is one that may sometimes be subtle yet dangerous - email addresses. Email addresses in a test system can inadvertently be used if the production...
-------------------
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
December 19, 2007 at 7:18 am
Barry McConnell (12/11/2007)
By confusion, I was...
-------------------
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
December 11, 2007 at 10:16 am
Barry McConnell (12/11/2007)
-------------------
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
December 11, 2007 at 8:45 am
Just my humble observation - and one that I haven't tested in SQL 2005 - is that a lack of a PK causes this issue in Enterprise Manager, assuming there...
-------------------
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
December 11, 2007 at 8:18 am
Thanks for the excellent article. It is the classic easier-said-than-done list, but given that I can see the value of all of the things you listed, I will take it...
-------------------
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
November 29, 2007 at 2:22 pm
PS - I don't see anywhere obvious where I can specify these connection options in ColdFusion - if anyone knows ColdFusion and can point it out if there is such...
-------------------
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
November 27, 2007 at 1:04 pm
Thanks,
The local server is SQL 2000. The linked server is SQL 2005.
Because this is a SELECT statement, I tried making a view, but I don't know if ANSI_NULLS and ANSI_WARNINGS...
-------------------
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
November 27, 2007 at 12:59 pm
OK, thanks,
Yes, though, that is what I meant. The queries on the new server fail with this error:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'table1'
I was...
-------------------
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
November 20, 2007 at 12:52 pm
Thanks again, Jeff,
We think we spotted one long-running query that was causing problems, so that is good since I think the developer was able to control it not to run...
-------------------
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
November 20, 2007 at 11:01 am
Thanks for everyone's advice.
About how much does Idera's Diagnostic Manager cost?
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
November 18, 2007 at 4:02 pm
Many thanks. I will consult that article.
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
November 17, 2007 at 10:14 pm
Thanks, Jeff,
The issue with the blocking in this case is that it results from queries waiting so long that they are causing the web site to run very slowly 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
November 17, 2007 at 9:21 pm
Thanks, absolutely, I don't think I would shrink the transaction file given the size it is now (around 1 GB). However, this application I have been introduced to seems 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
November 13, 2007 at 4:49 pm
Thanks for your reply.
I was looking at the ldf file in the file system. I understand that the file may stay the same size after a transaction log backup (a...
-------------------
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
November 13, 2007 at 4:33 pm
Viewing 15 posts - 991 through 1,005 (of 1,189 total)