Viewing 15 posts - 841 through 855 (of 901 total)
Thanks Joe, I come from an App dev background, and even though I've been writing SQL code for 8 years old habits are hard to get rid off. 🙂
March 7, 2011 at 2:08 am
I managed to figure out a more dynamic way of doing this using a couple of recursive CTE's one to traverse downt he hierarchy the second to traverse up the...
March 4, 2011 at 2:01 am
Changing the Instance name is a standard approach when installing multiple versins, if only to tell them apart.
As for the Account I meant is it using the Local...
March 2, 2011 at 4:55 am
you might want to check the Event logs on the PC to see the reason behind the failure, it might give you more insight.
What account is the SQL server service...
March 2, 2011 at 4:18 am
Gianluca Sartori (2/25/2011)
Sean Lange (2/25/2011)
...there is not a table to log against. This is no different than any other variable type.
Not true: operations on table variables are logged, but don't...
February 25, 2011 at 9:12 am
In my opinion a Table varialbe is great for very small data sets (1 or two columns, and less than 100 rows), any more than that and you should consider...
February 25, 2011 at 8:54 am
Sky,
seem your manager is non-tehnical and doesnt really understand the importance of the tempdb.
February 25, 2011 at 7:13 am
No Problem, It sometimes helps to have a second pair of eyes look at a problem. :crazy:
February 25, 2011 at 6:00 am
It seems that you are trying to create a linked list where the EndDate of the Membership is 1 Less than the start date of the next member_period.
The problem...
February 25, 2011 at 2:29 am
I'm not sure that setting the seed to the next number in logical order is the right way, Personally I would be setting the seed to start from a number...
February 24, 2011 at 2:14 am
There are some features that im looking forward to testing, especially the Lineage and Object Dependancy part of SSMS.
Of the New T-SQL commands THROW and the new addtions to the...
February 23, 2011 at 7:51 am
What is the insert volume of the table, as you really dont want to be initiating an SSIS package on every Insert if theres a high volumne of Inserts, as...
February 23, 2011 at 6:53 am
Koen Verbeeck (2/22/2011)
February 23, 2011 at 1:09 am
_Tups_ (2/21/2011)
http://social.msdn.microsoft.com
I never set the default member and I never set the isaggregate to false on the LatestFlag dimension...
So any...
February 21, 2011 at 8:23 am
Viewing 15 posts - 841 through 855 (of 901 total)