Viewing 15 posts - 571 through 585 (of 1,034 total)
Jeff Moden (5/2/2011)
mtassin (5/2/2011)
May 2, 2011 at 9:08 am
Jeff Moden (5/2/2011)
Hi Mark,Heh... I'm thinking T-Shirts with the classic "No RBAR" symbol on them to start with! 😀
For just $19.95 and if you're one of the first 20 callers...
May 2, 2011 at 8:29 am
Jeff Moden (5/2/2011)
mtassin (5/2/2011)
Lol I finally made a mention in one of Jeff's articles.Doesn't that help the performance hit from the concatenation in the where clause?
Hi Mark,
Heh... I'm thinking T-Shirts...
May 2, 2011 at 8:10 am
Lol I finally made a mention in one of Jeff's articles.
One day I'll have to collaborate with Jeff to define just what this alliance is.
On another note though, I notice...
May 2, 2011 at 7:39 am
Thanks Steve,
Learned something... not sure that I'll need to use it any time soon, but it's good to know.
April 29, 2011 at 8:18 am
opc.three (4/26/2011)
My take-away is to use config files (or tables) for parameter data 😀 Thanks for posting back.
That's my take away too... I thought using parameters to set variables would...
April 26, 2011 at 9:49 am
opc.three (4/25/2011)
Do you think it was a dtexec limit? an OS shell limit? other limit?
One of those two... regardless switching to a config file and specifying everything there resolved the...
April 26, 2011 at 7:34 am
It took a while, but I finally tracked it down.
The command line to set all those parameters was apparently too long. Depending on what I set for values, I...
April 25, 2011 at 12:19 pm
Not everybody uses Kerberos tickets to handle SQL authentication from windows accounts.
NTLM would block them a whole lot faster as authentication is done for each command. And there are...
April 25, 2011 at 12:09 pm
In SQL Server 2008 how many rows are gauranteed to be returned by the OUTPUT statement below?
With the awesomeness or NEWID I figured it could be any number of possible...
April 25, 2011 at 12:01 pm
Make a table...
CREATE TABLE [Daylightsavings](
[PK_dst_key] [int] IDENTITY(1,1) NOT NULL,
[dst_year] [int] NULL,
[dst_begin] [date] NULL,
[dst_end] [date] NULL,
[dst_diff] [int] NULL,
PRIMARY KEY CLUSTERED
(
[PK_dst_key] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY...
April 18, 2011 at 1:48 pm
I didn't know about FMTONLY ON ignoring IF/THEN blocks.
Based on that and the fact that FMTONLY is used to get a list of column names and data types
Why not add...
April 18, 2011 at 10:58 am
•Datetimeoffset whenever the data will refer to an exact point in time - transaction/added/updated datetimes (UTC) and localized datetimes.
•Datetime for any cases where the time is irrelevant across time zones...
April 18, 2011 at 7:41 am
SKYBVI (4/15/2011)
Horrible!!!This is sql server forum for people all over the world...
How can u ask questions related to US....????
Wat abt the people outside states??
Do they really matter? 😛
April 15, 2011 at 7:13 am
UMG Developer (4/14/2011)
From: http://www.irs.gov/newsroom/article/0,,id=233910,00.html
Taxpayers will have until Monday, April 18 to file their 2010 tax returns and pay any...
April 15, 2011 at 7:12 am
Viewing 15 posts - 571 through 585 (of 1,034 total)