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...
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...
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...
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...
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...
January 18, 2012 at 6:33 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......
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...
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.
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...
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...
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...
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...
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...
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...
January 17, 2012 at 9:05 am
Viewing 15 posts - 2,221 through 2,235 (of 14,953 total)