Viewing 15 posts - 13,741 through 13,755 (of 15,381 total)
LOL I have a real world example of why using a stored proc saved me plenty of time. We have a financial application that is used by a number of...
October 12, 2011 at 2:43 pm
I second that total loss of rational dbms concept on this however...this very topic was brought up just a couple days ago...http://www.sqlservercentral.com/Forums/Topic1188064-338-1.aspx
Albeit an incredibly bizarre requirement for sql to deal...
October 12, 2011 at 2:31 pm
jared-709193 (10/12/2011)
Sean Lange (10/12/2011)
MysteryJimbo (10/12/2011)
Sean Lange (10/12/2011)
I wouldn't argue the rationale for using NOLOCK as a routine hint for queries but I would say that performance IS the reason your...
October 12, 2011 at 1:20 pm
MysteryJimbo (10/12/2011)
Sean Lange (10/12/2011)
I wouldn't argue the rationale for using NOLOCK as a routine hint for queries but I would say that performance IS the reason your shop uses it....
October 12, 2011 at 1:05 pm
What is the question? The sql file you referenced is MySQL and not sql server.
October 12, 2011 at 10:40 am
MysteryJimbo (10/12/2011)
Ninja's_RGR'us (10/12/2011)
Once you tell them...
October 12, 2011 at 10:21 am
ANSI_PADDING is deprecated so just don't use it. http://msdn.microsoft.com/en-us/library/ms187403.aspx
What he was trying to explain is that the system will right pad with spaces any values into a char field...
October 12, 2011 at 9:20 am
Keep in mind that your trigger will still only capture data accurately for single row inserts.
-- @OUTPUT should receive the concatenation of the data separated with a pipe
...
October 12, 2011 at 8:57 am
Well It looks like it is around the variable @Name.
When looking for what that variable is...
DECLARE databases CURSOR FOR
SELECT NAME
FROM MASTER.DBO.SYSDATABASES
WHERE NAME = @NAME
Just curious...what is the point of that...
October 11, 2011 at 3:21 pm
What Elliot was eluding to is that you simply can't use a variable in the place of a server name like that. He was trying to find out some details...
October 11, 2011 at 2:51 pm
In fact, taking the data that J Livingston posted and modifying the column names to match, your query produced exactly the desired output you were looking for.
October 11, 2011 at 2:47 pm
I guess the implied thing was that I can't recreate your issue with the data in the format you posted it in. If you want to fix the data I...
October 11, 2011 at 2:00 pm
Your pivot appears to look fine. Given the data you posted it will return a single row. Your dates are all 1/1/1900 because they aren't wrapped with ''.
October 11, 2011 at 1:49 pm
Better but really I don't have time to turn your raw data into actual data. As both Kraig and I asked can you turn this into consumable data (Insert statements),...
October 11, 2011 at 1:09 pm
Dirty reads are not the best approach to improving performance. http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx
Typically the desire to use dirty reads in the guise of performance enhancement is trying to deal with the symptom...
October 11, 2011 at 12:26 pm
Viewing 15 posts - 13,741 through 13,755 (of 15,381 total)