Viewing 15 posts - 931 through 945 (of 1,415 total)
mwpowellhtx (3/17/2015)
patrickmcginnis59 10839 (3/17/2015)
ZZartin (3/17/2015)
So was this a question on why single character variable names @i and @j-2 are terrible choices?Ok lets see your choice for variable names!
given the execution...
March 17, 2015 at 11:09 am
ZZartin (3/17/2015)
So was this a question on why single character variable names @i and @j-2 are terrible choices?
Ok lets see your choice for variable names!
March 17, 2015 at 11:00 am
Doesn't work for me, I get
Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable "@j".
I'm pretty sure that when the code / batch completes, all variables become...
March 17, 2015 at 6:52 am
ccoscina (3/13/2015)
What I'm wondering is - if the orders table is currently being written to by the...
March 14, 2015 at 9:49 am
You need the alias "Unavailabledate" next to your column name in the first query:
with CLOSEDDATES AS (SELECT '2016-01-01 10:00' CLOSEDDATE)
,
RESERVATIONS AS (SELECT '2016-01-02 10:00' RESERVATIONDATE)
--SELECT [ClosedDate] FROM [ClosedDates] AS UnavailableDate...
March 13, 2015 at 2:31 pm
Just an opinion, but thats seems to be asking SSMA to be some sort of replication / transaction manager and I'd be surprised if this would go off without a...
March 13, 2015 at 10:29 am
Interestingly enough, your data post looks almost identical to the section of the linked article from my previous post titled "The Wrong Way to Post Data ".
Also you're labelling the...
March 5, 2015 at 7:07 am
We'll need sample data for this one so we can tell which key (join predicates) are duplicating.
This link http://www.sqlservercentral.com/articles/Best+Practices/61537/ will show the desired sample data formatting.
edit: obviously don't post...
March 5, 2015 at 6:28 am
Wayne West (3/3/2015)
patrickmcginnis59 10839 (3/3/2015)
...have your "stack smashed for fun and profit."
Hey! "Smash Your Stack For Fun and Profit!" is the name of my forthcoming intro programming book, how...
March 3, 2015 at 9:09 am
Don Halloran (3/3/2015)
Jeff Moden (3/2/2015) I told her that I'd do that right away and that I'd never touch front end code ever again after doing it. And, I...
March 3, 2015 at 8:53 am
Sean Lange (2/25/2015)
February 25, 2015 at 11:16 am
dwain.c (2/19/2015)
CELKO (2/18/2015)
I need to create random alphanumeric characters as primary key values when inserting a record [sic]. .. I don't want to use GUID or auto increment...
February 19, 2015 at 5:14 pm
Grant Fritchey (2/19/2015)
patrickmcginnis59 10839 (2/19/2015)
Eric M Russell (2/19/2015)
patrickmcginnis59 10839 (2/19/2015)Ok I'll bite, why is the row lookup slower on heaps? There is still an (invisible) key to the row.
OK
When a...
February 19, 2015 at 4:40 pm
Eric M Russell (2/19/2015)
patrickmcginnis59 10839 (2/19/2015)Ok I'll bite, why is the row lookup slower on heaps? There is still an (invisible) key to the row.
OK
When a table is non-clustered heap,...
February 19, 2015 at 3:45 pm
edited, I found a citation for Matt's description.
Matt Miller (#4) (2/19/2015)
patrickmcginnis59 10839 (2/19/2015)
One advantage of a clustered key is that it will benefit non-clustered indexes, because the clustered key is...
February 19, 2015 at 3:39 pm
Viewing 15 posts - 931 through 945 (of 1,415 total)