Viewing 15 posts - 9,781 through 9,795 (of 26,489 total)
sunny.tjk (9/6/2012)
I've a question, I ran the following query and when I looked at the execution plan it's just doing a table...
September 6, 2012 at 9:27 am
There is a slight problem with that function if you look closely enough (besides the fact that it is a scalar function). There are three entries for CST....
September 6, 2012 at 9:13 am
ryan.mcatee (9/6/2012)
Autumnstorms (9/6/2012)
I am pretty new to SQL & SQL Server and i'm having some trouble converting some date and time stored in our database...
We have a ticket application...
September 6, 2012 at 8:50 am
araman 5322 (9/6/2012)
Please check out this blog, might be helpful.http://www.wiseowl.co.uk/blog/s94/extra-space.htm
Thanks,
Arun.
Make it easier for others that may be interested:
September 6, 2012 at 8:47 am
Local temporary tables are only visible to the session that created them (even though you can see them in the sys.objects system view, which is what you should be using...
September 6, 2012 at 8:39 am
derek.colley (9/6/2012)
It was just a thought. Running through multiple transformational functions on each iteration seems intuitively wasteful.
Not sure what you are talking about here, multiple transformational functions on each...
September 6, 2012 at 8:33 am
sunny.tjk (9/6/2012)
September 6, 2012 at 8:32 am
saschup (9/5/2012)
I know this has an easy answer, but I can't find it anywhere or figure it out.
I have TableA with a column called ContactID. Some records have...
September 5, 2012 at 6:29 pm
jrichards54 (9/5/2012)
September 5, 2012 at 4:45 pm
Sqlism (9/5/2012)
i failed to upload.i cant see preview or image in the post
I tried 'reply'
than 'browse'
select image
'uploaded'
it dindt appeared in the post
If you look, you will see the attachment...
September 5, 2012 at 4:36 pm
L' Eomot Inversé (9/5/2012)
Lynn Pettis (9/5/2012)
Brandie Tarvin (9/5/2012)
Lynn Pettis (9/5/2012)
Brandie Tarvin (9/5/2012)
Lynn Pettis (9/5/2012)
Really finding it painful to not respond to jc and his responses, but I'm trying not to.
Have...
September 5, 2012 at 3:37 pm
SQL_Bob (9/5/2012)
I of course can't guarantee anything, but given...
September 5, 2012 at 1:35 pm
You do know that tempdb is recreated when SQL Server is restarted, correct? That will clear all your orphaned temp tables for you. Of course you need a...
September 5, 2012 at 1:28 pm
Brandie Tarvin (9/5/2012)
Lynn Pettis (9/5/2012)
Brandie Tarvin (9/5/2012)
Lynn Pettis (9/5/2012)
Really finding it painful to not respond to jc and his responses, but I'm trying not to.Have a cookie.
Oatmeal Raisin if you...
September 5, 2012 at 1:22 pm
Viewing 15 posts - 9,781 through 9,795 (of 26,489 total)