Viewing 15 posts - 1,081 through 1,095 (of 1,189 total)
Here is mine. I did it without % because I couldn't find the mod function by name in Books Online and did not want to give in and go 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 30, 2007 at 11:46 am
I completely agree and did the same thing! I have to wonder whether there is something wrong with this approach that would preclude from being used as the behavior 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 30, 2007 at 10:28 am
Ha ha!
Sample dialogue using the 'B' answer:
BOSS: I see you are querying an offline cube in Analysis Services. Can I access your cube as well to perform some analysis?
DBA:...
-------------------
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 25, 2007 at 10:04 am
That's a good point about Apple. They certainly have that reputation, and it has been furthered by a jealously loyal user base.
How much of that reputation is based on 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
May 21, 2007 at 9:47 am
Since the query returns the number and the names (if you run it in Query Analyzer the number shows up for you in the status bar anyway), I didn't see...
-------------------
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, 2007 at 9:19 am
My completely anecdotally based guess is that it will be at least a generation (20-30 years) before anything like real 100% automation exists for an entire company's IT infrastructure -...
-------------------
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, 2007 at 8:43 am
I agree. I was tempted to pick A, but (and perhaps I was reading the question too literally) picked D because the question said the cost had to be below...
-------------------
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 17, 2007 at 7:45 am
In principle there is no difference, but in PR terms there may be. People may have the wrong impression that a system is automatically more secure when it uses 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
May 17, 2007 at 7:17 am
Thanks! I think it turned out that the performance issue in this case was not due to the database, which supports your suggestion that the tlog size was not 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 10, 2007 at 12:36 pm
Just an update - the transaction log file size is now up to about 2 GB.
Is this OK?
Thanks again.
----
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 5, 2007 at 6:58 am
We are on SP1. SP2 had some trouble so we have not moved to it yet.
I ended up writing a T-SQL procedure to do the deletions, based on an example...
-------------------
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 2, 2007 at 7:53 am
I know the feeling. Looking forward to getting the script if you can post it.
Thanks again!
---
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 1, 2007 at 6:40 pm
Thanks, that is good to know. So a database that is, say, 610 MB, with a tlog file that is 615 MB, is not necessarily bad?
In terms of performance,...
-------------------
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
April 30, 2007 at 10:33 am
Hi, and thanks,
The reason I think it is too large is that it is larger than the database file itself (the .mdf file). I thought that was a sign 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
April 30, 2007 at 10:15 am
Thanks for your reply. I'll try to answer your questions as best I can.
We run transaction log backups every hour. We make a full backup once per dayat 6:00 pm....
-------------------
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
April 27, 2007 at 6:19 pm
Viewing 15 posts - 1,081 through 1,095 (of 1,189 total)