Viewing 15 posts - 1,591 through 1,605 (of 1,838 total)
I suppose the biggest problem I have with the physical working environment is it seems cubicles have gotten smaller and smaller over the years. Also, the current place I...
January 6, 2009 at 7:40 am
dubem1 (1/4/2009)
...No calculation will be made with the value of the column...
While there may not be any requirement currently for calculations, I could easily see sorts or some kind of...
January 5, 2009 at 12:06 pm
Andrew Gothard (1/5/2009)
RBarryYoung (12/21/2008)
January 5, 2009 at 11:53 am
PaulB (1/2/2009)
Understood, it makes sense but, it doesn't mean the practice should be considered "best practice" as original poster has asked. Am I correct?
If you have some actual information to...
January 4, 2009 at 7:51 pm
PaulB (12/31/2008)
Nice. I'm pretty sure your SOX auditors are loving it, isn't it?
Well, as I've stated previously I'm not really a .Net person, more a database person, so I'm just...
January 2, 2009 at 6:36 am
Adi is right that IDENTITY certainly will not prevent gaps, and the reason is that it needs to protect the integrity of the column. So while the 3rd insert...
December 31, 2008 at 8:31 am
:unsure: another good question with bad answer choices unfortunately.
http://technet.microsoft.com/en-us/library/ms178560(SQL.90).aspx
says: "sp_update_jobschedule is provided for backward compatibility only" so it still works, just Microsoft in their infinite wisdom decided to change it...
December 31, 2008 at 7:47 am
Well, I'm just a little bit of a .Net person, mostly a database person, but in simplest terms, yes, each different SQL Server login user would require a different connection...
December 31, 2008 at 7:30 am
:Wow: Can't we just all get along??? Personally I think there are things worse than semicolons in SQL, but I'm not going to get into them here. 😛
December 31, 2008 at 7:22 am
PaulB (12/30/2008)
I can see your organization has very flexible security policies
Well, we have to maintain and enforce security within our applications, instead of relying on Active Directory / Windows Authentication...
December 30, 2008 at 2:54 pm
I believe the UPDATE statement at the end of each script probably has alot to do with it. Running Profiler on these two scripts on my development server (4...
December 30, 2008 at 12:25 pm
PaulB (12/30/2008)
...there are no differences in between planning for an Intranet or any other kind of application...
Whlie this would be true for your data modeling and schema design, it probably...
December 30, 2008 at 9:24 am
Thank you Bob!
I understand why people don't want to just do other people's work, there are times in these forums I wonder if the original posters ever even heard of...
December 29, 2008 at 2:18 pm
Matt Miller (12/29/2008)
That's ok Noel - Chris harshman already posted something similar on the OTHER thread the OP started on the same topic....:http://www.sqlservercentral.com/Forums/Topic626424-360-1.aspx
enjoy!
:rolleyes: Oh well, I just happened to...
December 29, 2008 at 1:47 pm
Yes, a recursive CTE solves this rather nicely:
;WITH WGBizTree (bid, bname, wgid, wgname) AS
-- anchor part
(SELECT wb.bid, b.name AS bname, wb.wgid, w.name...
December 29, 2008 at 10:26 am
Viewing 15 posts - 1,591 through 1,605 (of 1,838 total)