Viewing 15 posts - 2,221 through 2,235 (of 14,953 total)
It'll depend on how the application was written.
It's a best practice to have all applications on a web server share a single data connection configuration, often in a Data Access...
- 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
January 18, 2012 at 9:17 am
Another, usually better, option is break open the procedure and turn it into an operation that can take a whole table of "parameters" and work on them in a set-based...
- 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
January 18, 2012 at 9:14 am
Stat and index tuning are good starting points.
Wait states can tell you about hardware bottlenecks, if there are any.
Confio Ignite or one of its competitors can be a great way...
- 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
January 18, 2012 at 9:08 am
There are a lot of books on SQL Server that would give you some insight into what you're asking for.
One great author on the subject is Itzik Ben-Gan. List...
- 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
January 18, 2012 at 6:39 am
Most applications (web or thick) have a connection string stored somewhere in them that points them to the correct server and database, and usually includes something about the credentials to...
- 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
January 18, 2012 at 6:33 am
If I were required to bring my own tools (laptop, RedGate toolbelt, SQL Dev Edition, et al), then it would also be necessary for the employer to recognize that it's...
- 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
January 18, 2012 at 6:31 am
Jeff Moden (1/17/2012)
GSquared (1/17/2012)
Yep. But that doesn't grant access to a database their account/group hasn't been given access to, except as "guest". So guest has to be enabled.
Ah......
- 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
January 18, 2012 at 6:12 am
Build a calendar table, join to that using Between on your start and end dates.
The calendar table should have all dates in a reasonable range (I like 50 years for...
- 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
January 17, 2012 at 1:56 pm
Per Oracle, Numeric is for fixed and floating point numbers. That's more similar to SQL Server's Float/Real datatype.
- 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
January 17, 2012 at 1:54 pm
L' Eomot Inversé (1/17/2012)
GSquared (1/17/2012)
Is the actual business requirement simply a count of how many distinct datakeys there...
- 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
January 17, 2012 at 1:52 pm
Honestly, my best suggestion is don't use the T-SQL Pivot operator. Pivot in the presentation layer. Excel, SSRS, Crystal Reports, are all MUCH better at pivot table operations...
- 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
January 17, 2012 at 1:40 pm
Marios Philippopoulos (1/17/2012)
GSquared (1/17/2012)
Jeff Moden (1/16/2012)
rlevine (1/16/2012)
I was able to install my CLR functions into a db called Library and then use these scripts to enable having all users call...
- 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
January 17, 2012 at 1:37 pm
Jeff Moden (1/17/2012)
GSquared (1/17/2012)
Jeff Moden (1/16/2012)
rlevine (1/16/2012)
I was able to install my CLR functions into a db called Library and then use these scripts to enable having all users call...
- 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
January 17, 2012 at 1:36 pm
I think this whole thing may be getting massively overcomplicated by the math.
Is the actual business requirement simply a count of how many distinct datakeys there are, and a count...
- 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
January 17, 2012 at 12:00 pm
L' Eomot Inversé (1/17/2012)
Jeff Moden (1/16/2012)
I'll reserve my opinion on this but thought I'd give everyone a heads up...http://wikimediafoundation.org/wiki/English_Wikipedia_anti-SOPA_blackout
I believe (sadly) that this will have no effect at all...
- 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
January 17, 2012 at 9:05 am
Viewing 15 posts - 2,221 through 2,235 (of 14,953 total)