Viewing 15 posts - 286 through 300 (of 370 total)
Just keep in mind that your client must have MS Office installed for that to work. 🙂
But that could work.
Now to the experts: Is a CLR stored procedure a bad...
September 27, 2011 at 8:06 pm
Wonderful advices! Thank you.
Some day I'll put them to good use (not a DBA yet) but I'm gathering knowledge to become one.
Oh, and I'd really love to see zombies ruling...
September 26, 2011 at 5:45 pm
pelusodm (9/26/2011)
September 26, 2011 at 4:18 pm
The only circumstances that I'll use dynamic sql is in those that there's no other way around it.
Example:
SELECT * FROM OPENROWSET(BULK @FileName, SINGLE_CLOB) AS Temp;
Because the OPENROWSET command will not...
September 26, 2011 at 3:09 pm
Ninja's_RGR'us (9/26/2011)
codebyo (9/26/2011)
Ninja's_RGR'us (9/26/2011)I've not tested that way either. What I do is save the output (only errors) and if anything is inserted into the logging table then I...
September 26, 2011 at 8:07 am
Ninja's_RGR'us (9/26/2011)I've not tested that way either. What I do is save the output (only errors) and if anything is inserted into the logging table then I assume something...
September 26, 2011 at 7:03 am
Isn't it possible that at the end of the "DBCC CHECKDB" step you would choose "On failure action" as "Quit the job reporting failure" and all of the next steps...
September 26, 2011 at 5:45 am
Great question.
The precedence of operators, in that case, will make all the difference.
Since it's math, if we use parenthesis, we'll get a different result as expected.
SELECT '2' + '3' *...
September 26, 2011 at 5:28 am
Also you could use the "yyyymmdd" format without any "-" or "/" characters and they'll be accepted with any settings. It's a safe bet.
Best regards,
September 24, 2011 at 8:32 pm
SQL Kiwi (9/23/2011)Adam (Machanic) would no doubt want me to encourage you to share a link to SQLblog instead (traffic = advertising = pays the hosting bills) but I understand...
September 24, 2011 at 8:38 am
SQL Kiwi (9/23/2011)
http://sqlblog.com/blogs/paul_white/archive/2010/08/05/iterators-query-plans-and-why-they-run-backwards.aspx
I have been following your blog for some time now but I hadn't found that article before. I have much to learn and I appreciate those links.
Can I...
September 23, 2011 at 7:52 pm
Amazing question. Thank you.
Now I must confess that I got it right completely by luck but with a trail of thought that TRUNCATE TABLE is minimally logged and doesn't affect...
September 23, 2011 at 7:37 pm
Thank you for such an amazing question, Paul.
I got it right because I always remember reading that the "top (outer) input" is read first and then it goes look for...
September 22, 2011 at 2:52 pm
SQL Kiwi (9/19/2011)
SELECT
id =
CASE
WHEN GROUPING(e.id) = 1 THEN 'Total'
ELSE CONVERT(VARCHAR(12), e.id)
END,
...
September 19, 2011 at 5:40 pm
Got it wrong.
I thought that there would be an error because the StudentId column has the alias "StudentNumber" inside the subquery and in line 25 it's being declared as StudentId...
September 17, 2011 at 1:55 pm
Viewing 15 posts - 286 through 300 (of 370 total)