webrunner

Forum Replies Created

Viewing 15 posts - 346 through 360 (of 1,189 total)

RE: Possible root causes of 'tempdb' is full due to 'ACTIVE_TRANSACTION'

TheSQLGuru (4/8/2016)
It is critically important to gather as much forensics as possible before pulling the plug. Often with good diagnosis the sledge-hammer approach isn't even necessary. But regardless, if...
-------------------
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 8, 2016 at 11:57 am

#1870894
RE: Seeking advice on upgrade - SQL 2014 vs SQL 2016

Great, thanks for your advice on this!
- 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

April 7, 2016 at 3:52 pm

#1870682
RE: Seeking advice on upgrade - SQL 2014 vs SQL 2016

Thanks to everyone for their answers! I know your answers are not intended to say "you should go to SQL 2016," but I appreciate the feedback consensus, which I did...
-------------------
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 6, 2016 at 9:34 am

#1870226
RE: Seeking advice on upgrade - SQL 2014 vs SQL 2016

TheSQLGuru (4/5/2016)
You didn't give us anything at all to go on to advise you. In particular what edition of SQL Server are you on now and are you (or could...
-------------------
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 6, 2016 at 9:31 am

#1870222
RE: Unique Constraints

Thanks for the question. 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

March 29, 2016 at 8:44 am

#1868270
RE: SSIS import of multiple, variably named CSV files

Thanks all for your replies! Especially given the crazy nature of the file setup. I think I have enough advice to figure out what to try (the idea of populating...
-------------------
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

March 29, 2016 at 7:51 am

#1868233
RE: QOTD Truncating Identity

Wayne West (3/9/2016)
Comments posted to this topic are about the item <A HREF="/questions/IDENTITY/138589/">QOTD Truncating Identity</A>
Thanks, great question. I incorrectly chose 0 but 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

March 11, 2016 at 8:54 am

#1864608
RE: EncryptbyPassPhrase

Thanks for the question. I didn't know that.
- 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

February 25, 2016 at 9:24 am

#1861133
RE: CHECKING specific values

sknox (2/23/2016)
...
The check constraint process isn't "I only want you to insert values that are in the following list", but "I want you to refuse values that fail this test"....
-------------------
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

February 23, 2016 at 9:15 am

#1860457
RE: The Path

Thanks - great question.
- 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

February 19, 2016 at 8:40 am

#1859842
RE: The Push to Upgrade from SQL Server 2005

Thanks for this info, Steve!!
- 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

February 12, 2016 at 8:33 am

#1858386
RE: Audit which users can perform destructive tasks

Thanks!! That is a big help.
- webrunnr
-------------------
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

February 12, 2016 at 8:30 am

#1858381
RE: SSIS fail out of Foreach loop to stop processing

Brandie Tarvin (2/12/2016)
webrunner (2/12/2016)
I eventually found out what was happening.
I was using @[User::Variable] = 0 instead of the operator to check for equality @[User::Variable] == 0. Once I fixed that...
-------------------
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

February 12, 2016 at 8:22 am

#1858376
RE: SSIS fail out of Foreach loop to stop processing

Thanks for that advice - I'll definitely check it out.
In the meantime, for this problem, I eventually found out what was happening.
I was using @[User::Variable] = 0 instead of 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

February 12, 2016 at 7:43 am

#1858348
RE: Audit which users can perform destructive tasks

Brandie Tarvin (2/12/2016)
A great way to impress your boss is to create a daily or weekly "Entitlement" report that documents these permissions in all environments. Have the report dumped 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

February 12, 2016 at 7:40 am

#1858345

Viewing 15 posts - 346 through 360 (of 1,189 total)