Viewing 15 posts - 5,746 through 5,760 (of 6,041 total)
In the database realm, I don't hear the phrase "It works on my machine but not in production", but it's not uncommon to hear "It works in QA but not...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 26, 2011 at 8:35 am
"Where are the doughnuts? We used to always have doughnuts on Friday morning."
:rolleyes:
http://www.sqlservercentral.com/Forums/Topic944353-263-1.aspx
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 26, 2011 at 7:47 am
Developing T-SQL is like gourmet cooking; you accumulate recipes and techniques over the years; adopt from books and the experts on TV, and then improvise in your own kitchen. If...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 25, 2011 at 1:32 pm
As others have already pointed out, your current table design won't allow you to reliably query only those rows inserted as of a specific date. For what it's worth, just...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 25, 2011 at 1:12 pm
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 24, 2011 at 12:53 pm
sqldba_icon (1/20/2011)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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)...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 18, 2011 at 4:01 pm
Viewing 15 posts - 5,746 through 5,760 (of 6,041 total)