Viewing 15 posts - 5,731 through 5,745 (of 6,022 total)
SQL and T-SQL code tends to be derivative, especially if it's a general purpose script intended to do something like return the name of all unused indexes. Not to diminish...
January 25, 2011 at 8:27 am
sqldba_icon (1/24/2011)
Actually i thought of the same but is that how others do or just a temp fix?
It shouldn't take 20+ seconds for SQL Server to compile an execution plan...
January 24, 2011 at 12:53 pm
sqldba_icon (1/20/2011)
January 24, 2011 at 7:37 am
There are a lot of mistakes developers make regarding dates and data types; an entire presentation could cover this topic alone.
For example:
- Containing "date" values (ex: 3/10/09, 09/10/03, 3-10)...
January 24, 2011 at 7:23 am
If what you're wanting to do is BEGIN TRANSACTION, and then at some point have the option to ROLLBACK a unit of work while still having the option to COMMIT...
January 21, 2011 at 2:47 pm
Try letting the Database Tuning Advisor analyze a few of these batches loads and see what it reccomends.
January 20, 2011 at 12:23 pm
Taking a minimalist approach, SQL Server's Import and Export Wizard, which is accessible by right clicking on a database in SSMS, provides the option to save the process to a...
January 19, 2011 at 1:35 pm
Even if you build what you believe to be the perfect BI application that presents every posible key preformance indicator, you can't actually expose it to end users without upper...
January 19, 2011 at 8:27 am
Steve Jones - SSC Editor (1/18/2011)
I don't see these as holes in SSIS, but more potential holes in process using SSIS.
Right, a SSIS package is just an XML document, so...
January 19, 2011 at 6:01 am
Craig Farrell (1/18/2011)
Your department head and data integrity are miles above the average company I've worked in. That includes financial firms and healthcare providers. No I won't mention...
January 19, 2011 at 5:48 am
Craig Farrell (1/18/2011)
Without anyone usually having the holistic view of everything occuring with any piece of data, we're spiraling out of intelligent data access control. We need to find...
January 18, 2011 at 4:01 pm
Any project where there is a need to analyze the data scientifically will typically have real scientists on staff on contract. I've worked on projects side by side with statisticians...
January 18, 2011 at 2:00 pm
SanDroid (1/17/2011)
...
Eric, I agree with you but this does not agree with any BI project that accessed sensitive data that I have seen.
short story: All Company Security starts...
January 17, 2011 at 3:50 pm
marco-870908 (1/17/2011)
January 17, 2011 at 3:13 pm
Regarding the scurity of the ETL (or reporting) tools themselves, the biggest concern is not embedding login credentials into the package. The package should login using Windows Authentication and a...
January 17, 2011 at 11:44 am
Viewing 15 posts - 5,731 through 5,745 (of 6,022 total)