Viewing 15 posts - 7,381 through 7,395 (of 14,953 total)
Ray K (12/18/2009)
I remember an instance where I'd prefer the embedded code direction...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 21, 2009 at 7:27 am
Adam Gojdas (12/18/2009)
GSquared (12/18/2009)
Your version will raise a priority 16 error that will abort that batch, but it will then continue to run from the next GO statement, which can...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 21, 2009 at 7:16 am
The answer depends on a lot of things.
First, moving the code to stored procedures helps with security, because it can be used to help prevent SQL injection attacks. Those...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 18, 2009 at 12:37 pm
jcrawf02 (12/18/2009)
GSquared (12/18/2009)
Steve Jones - Editor (12/18/2009)
Any guesses on the new architecture?
Black, metalic cases, with cooling fans. Lots of little lights, but not so many as the bridge of...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 18, 2009 at 12:18 pm
Why bother denormalizing it this way? Why not just query aggregates? It looks to me like you could get rid of the VersionMaster table completely, or replace it...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 18, 2009 at 11:44 am
Steve Jones - Editor (12/18/2009)
Any guesses on the new architecture?
Black, metalic cases, with cooling fans. Lots of little lights, but not so many as the bridge of The Enterprise.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 18, 2009 at 11:23 am
BaldingLoopMan (12/17/2009)
If i'm writting production level stored procs that must be optimized then i would put everything that exist in the ON statement in the WHERE as well when...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 18, 2009 at 6:55 am
Adam Gojdas (12/17/2009)
GSquared (12/17/2009)
I agree, but I add an additional check.
if object_id(N'[ProcName]','P') is null and object_id(N'[ProcName]') is not null
raiserror('Object name in use', 21, 1) with log;
That...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 18, 2009 at 6:48 am
The Dixie Flatline (12/17/2009)
Is it just me, or is there a sudden frenzy of demands right at the end of the year?
Probably people trying to solve things before they take...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 17, 2009 at 2:06 pm
Build a calendar table. Solve the problem once, then just use that to join to.
You can have "FiscalMonth" as a column in the table, along with the usual "DayOfWeek",...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 17, 2009 at 2:05 pm
I can't say that I have well-articulated architectural principles, but I do have policies that I follow. I just haven't taken the time to write very many of them...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 17, 2009 at 2:00 pm
I'd uninstall the whole package. Dev Edition comes with the same things, but with more powerful versions. Management Studio, for example, is much more limited in Express than...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 17, 2009 at 1:49 pm
The order in the Where clause won't matter, since the engine will make its own decisions on that subject.
The deciding factor on whether to put something in the Join clause...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 17, 2009 at 1:47 pm
If you can build CLR stored procedures (more secure and flexible than the sp_OA... procs), this page has one that's worked well for me for drive space:
http://weblogs.sqlteam.com/tarad/archive/2007/12/18/60435.aspx
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 17, 2009 at 1:43 pm
Rebuilding indexes automatically updates the stats. Reorganizing indexes does not.
There's good data on rebuilds here http://sqlserverpedia.com/blog/sql-server-bloggers/update-statistics-before-or-after-an-index-rebuild/.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 17, 2009 at 1:38 pm
Viewing 15 posts - 7,381 through 7,395 (of 14,953 total)