webrunner

Forum Replies Created

Viewing 15 posts - 286 through 300 (of 1,189 total)

RE: Huge tempdb log file

Thanks for the question and the comment thread.
Does anyone know why it is so difficult (it seems) to know exactly which queries or SPIDs are the culprits for these cases...
-------------------
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 1, 2016 at 1:25 pm

#1909991
RE: Potential presentation idea: The magic of checklists

Ray K (10/21/2016)
Bill Talada (10/21/2016)
I listened to the following great audio book from my local free library which may give you some excellent ideas for a presentation. 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

November 1, 2016 at 12:57 pm

#1909984
RE: Trailing

Thanks for the question. I got it right only because I've seen it work. Not sure why it is allowed, though.
- 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

October 11, 2016 at 10:34 am

#1905937
RE: Help with SQL 2012 to SQL 2016 P2V considerations

wtren (10/11/2016)
normally you should ask vmware about the licenses choice and cost, generally sql server virulization it will have some negative performance effect, but you also got administration flexibility...
-------------------
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

October 11, 2016 at 8:15 am

#1905906
RE: Help with SQL 2012 to SQL 2016 P2V considerations

Thanks very much for your feedback. We are going to enlist help from Microsoft in addition to my own assessment of our current environment.
- 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

October 10, 2016 at 8:29 am

#1905665
RE: How to grant view definition access only on Views & Functions in SQL Server 2K8R2

Sean Lange (7/23/2012)
To add to Capn's response, the following script can be tweaked to generate the sql you need.
declare @login VARCHAR(30) = 'UserID'
SELECT 'Grant View Definition ON ' + schema_name(schema_id)...
-------------------
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

September 29, 2016 at 12:21 pm

#1904015
RE: The Christmas CROSS APPLY

Wow, that's some crazy SQL! Thanks for the cool question, though. 🙂
- 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

September 29, 2016 at 8:22 am

#1903968
RE: Comparing with NULL

Thanks, great question.
- webrunner
P.S. I see the following code returns false, true.
SELECT CASE
WHEN (9999 IS NULL)...
-------------------
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

September 27, 2016 at 9:04 am

#1903379
RE: Capture the Flag

Eric M Russell (9/23/2016)
Yet Another DBA (9/23/2016)
It is narrow-AI and not general-AI (which is what WATSON is trying to be).
If we have problems with developers running feral in 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

September 23, 2016 at 7:48 am

#1902780
RE: Capture the Flag

Steve Jones - SSC Editor (9/22/2016)
I decided not to stoke more fears than necessary.
+1 Great point. In fact, I realize I should not have posted 'Skynet' because 'Skynet' could very...
-------------------
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

September 22, 2016 at 3:28 pm

#1902668
RE: Capture the Flag

No love for Skynet in this editorial? :hehe:
-------------------
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

September 22, 2016 at 12:46 pm

#1902615
RE: Backup History for all databases

Thanks for the script!
- 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

September 21, 2016 at 8:36 am

#1902193
RE: Logical processors

Thanks for the question, Igor!
I learned something.
- 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

September 21, 2016 at 8:31 am

#1902189
RE: Why We Need Backups First

Gary Varga (9/20/2016)
webrunner (9/20/2016)
That's a fairly egregious breach of duty for some IT personnel in this case. The system was installed in 2009, and this event apparently occurred during 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

September 20, 2016 at 9:07 am

#1901912
RE: Why We Need Backups First

That's a fairly egregious breach of duty for some IT personnel in this case. The system was installed in 2009, and this event apparently occurred during a software upgrade in...
-------------------
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

September 20, 2016 at 8:36 am

#1901893

Viewing 15 posts - 286 through 300 (of 1,189 total)