Viewing 15 posts - 646 through 660 (of 667 total)
Sure it will, appreciate it if you would. Have been looking into exec plans with CROSS APPLY from a physical table to a UDF returing a table today as well....
March 5, 2009 at 2:03 pm
GilaMonster (3/5/2009)
Derek Dongray (3/5/2009)
Also I'd be interested to see the source of the User-defined function FFG_FX_JUST_DATE since, although it doesn't add the the estimated cost
Scalar functions never do. It's one...
March 5, 2009 at 1:47 pm
I'm not 100 percent sure, but I vaguely remember reading that Visual Studio Team Edition for Database Professionals allows you to extract an entire schema and store it in TFS.
February 18, 2009 at 3:16 am
I agree with Warren. I read the same BOL article and that's why I answered YES.
By the way, the MSDN article quoted to justify NO being the correct answer doesn't...
January 21, 2009 at 4:28 am
Add /S to the command line as well. Just be careful to run it in the intended directory! I once wiped almost my entire harddrive because I inadvertently ran it...
November 14, 2008 at 5:30 am
Hi Daniel,
Just an idea, but why don't you first fix those dates/datetimes in MySql BEFORE you try to transfer the data to SQL? That's of course assuming that you can...
October 15, 2008 at 6:09 am
Good Luck, Gail! I wish there was a User Group in Cape Town as well.
October 9, 2008 at 7:02 am
In BOL under ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/ee6b9116-a7ff-463a-a9f0-b360804d8678.htm
it is worded slightly differently in that it says
You can create up to 249 spatial indexes on each spatial column in a table.
That also leads be to...
September 5, 2008 at 6:10 am
Try this version using a Tally table. No loops, no cursors.
IF OBJECT_ID ( 'tempdb..#Tally' ) IS NOT NULL
BEGIN
DROP TABLE #Tally
END
GO
DECLARE @AlphaNumber varchar ( 20 )
DEcLARE @numtoadd ...
August 29, 2008 at 5:10 am
Brilliant article! Reminds me somehow of one of my colleagues who wrote the following in C:
int x = 1;
int y = 2;
x ^= y ^= x ^= y;
just to swap...
August 5, 2008 at 6:01 am
The answer doesn't seem to be 100 percent accurate. If you look up BOL ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/016fb05e-a702-484b-bd2a-a6eabd0d76fd.htm under SNAPSHOT ISOLATION it reads:
Except when a database is being recovered, SNAPSHOT transactions do not...
July 16, 2008 at 8:38 am
Jacob,
Have a look at http://www.sqlservercentral.com/articles/Security/sqlserversecurityprosandconsofapplicationroles/1116/. Keep in mind though that the article was written in 2003, so it pertains to application roles as they were implemented in SQL2K. Things may...
July 15, 2008 at 4:40 am
jim.powers (7/3/2008)
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
In the Workgroup column on the row for RAM, the limit is clearly...
July 3, 2008 at 7:57 am
You are right about the URL Kev. Don't ask me how I managed to drop that "b" when copying and pasting.
And yes, you are right when you say that the...
July 3, 2008 at 5:35 am
But if you look at
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/09bcf20b-0a40-4131-907f-61479d5e4d8.htm
in BOL it reads "Operating system maximum".
To me 3GB looks more like a limit imposed by Windows 32 bit architecture on an x86 machine. Has anyone...
July 3, 2008 at 5:03 am
Viewing 15 posts - 646 through 660 (of 667 total)