Viewing 15 posts - 6,466 through 6,480 (of 26,490 total)
EDIT: Looks like Chris found the issue with the part I did. Now to try and figure out the rest.
I found the problem, try the following:
IF OBJECT_ID ('tempdb..#GLT') IS...
June 25, 2014 at 8:06 am
I didn't say that the indexes would improve performance only that table variables CAN have indexes, you just have to create them when declaring the table variable. The optimizer...
June 24, 2014 at 3:15 pm
tcronin 95651 (6/24/2014)
June 24, 2014 at 3:10 pm
This is the part the jumped out at me:
Unable to find the requested .Net Framework Data Provider. It may not be installed. (System.Data)
I'd look to see if the .Net framkwork...
June 24, 2014 at 3:02 pm
Andrew Kernodle (6/24/2014)
Table variables don't have optimization statistics...
June 24, 2014 at 2:59 pm
You are correct, for large amounts of data table variables are not a good choice. As with everything else in SQL Server it comes down to using the right...
June 24, 2014 at 2:44 pm
I haven't heard this, but I also know that used properly they have a very good use. I have used them to capture data that needed to survive a...
June 24, 2014 at 2:39 pm
Sean Lange (6/24/2014)
Mr. Kapsicum (6/24/2014)
Moreover, the Query you provided I.e SELECT GETDATE()+10 will add 10 Days to current date.Can anyone please explain this.?
Thanks in advance.
You discovered one of those (un)documented...
June 24, 2014 at 11:16 am
Lynn Pettis (6/24/2014)
Ed Wagner (6/24/2014)
Lynn Pettis (6/24/2014)
Help me, help me. I don't know how to use BOL or Google! I need to add 10 years to...
June 24, 2014 at 11:01 am
Ed Wagner (6/24/2014)
Lynn Pettis (6/24/2014)
Help me, help me. I don't know how to use BOL or Google! I need to add 10 years to the current...
June 24, 2014 at 11:00 am
BOR15K (6/24/2014)
Thanks, but found the issue already - that problematic DB of mine had a compatibility set back to 80 (2005). Once changed, all is working.Thanks again.
Actually, compatibility level 80...
June 24, 2014 at 10:56 am
< rant >
Help me, help me. I don't know how to use BOL or Google! I need to add 10 years to the current date and getdate() +...
June 24, 2014 at 10:53 am
river1 (6/24/2014)
Hi,I want to add 10 years to the current date.
select getdate()
I made:
select getdate() +10 but it does not work.
Thank you
Try:
dateadd(year,10,getdate())
June 24, 2014 at 10:50 am
Oracle_91 (6/24/2014)
Thank you. I was able to fix by myself by doing some google search.http://stackoverflow.com/questions/1252335/send-mail-via-gmail-with-powershell-v2s-send-mailmessage
First, instead of posting a link it would have been better to post your actual fix.
Second,...
June 24, 2014 at 8:17 am
One for three when shooting from hip. Love the complaints when the info provided is lacking.
June 23, 2014 at 2:48 pm
Viewing 15 posts - 6,466 through 6,480 (of 26,490 total)