Viewing 15 posts - 3,301 through 3,315 (of 6,041 total)
What type of feedback; regarding whether you've modeled right logical architecture (facts, measures, schema, etc.) to support end user's requirements, or whether you've got a solid physical architecture (server hardware,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 13, 2015 at 3:22 pm
Taking your story at face value, assuming it's not all in your head, it sounds like your current and previous job are on the crappy side of the bell curve....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 13, 2015 at 2:58 pm
So, you have a table with ~2,000k rows, you're deleting ~750k rows in batches of 50k, it's taking ~10 minutes, and you want to minimize the runtime duration. I'm guessing...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 13, 2015 at 10:29 am
Data Governance is a lot simpler when databases and IT teams are not operating in silos. It helps if there is one application for each line of business, one set...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 13, 2015 at 7:02 am
SQLmansell (10/12/2015)
Eric M Russell (10/12/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 12, 2015 at 2:00 pm
Temporary tables, spools, hashes, etc. are not tied to any specific database. For example, assuming we wanted to have a separate temporary work area for each databases, if you have...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 12, 2015 at 1:29 pm
ScottPletcher (10/12/2015)
Eric M Russell (10/12/2015)
Kristen-173977 (10/9/2015)
Eric M Russell (10/9/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 12, 2015 at 12:15 pm
Meatloaf (10/12/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 12, 2015 at 11:08 am
I could see a scenario where new hardware is purchased for the database server, and the old hardware ends up donated to the Development team or for sale on the...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 12, 2015 at 10:55 am
If nothing else, TDE protects IT from the intrusion of nosy compliance auditors. However, as you know, there are other options for implementing data at rest encryption that might work...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 12, 2015 at 10:47 am
When it comes to data governance, in the absence of any preexisting official documentation and governance, there simply is no deterministic truth. You're attempting to measure something that is subjective...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 12, 2015 at 8:11 am
This was our philosophy when we built Chaos Monkey, a tool that randomly disables our production instances to make sure we can survive this common type of failure without any...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 12, 2015 at 7:31 am
Kristen-173977 (10/9/2015)
Eric M Russell (10/9/2015)
Stuff like aliasing column names and stripping quotes from column values can be easily handled within the view or stored procedure, from which BCP exports.
Yeah, but...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 12, 2015 at 6:56 am
The following doesn't use an UDF or CLR, and seems to cover all the (4) scenarios you described above.
declare @Invoice as table( BillID varchar(20) primary key );
insert into @Invoice...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 9, 2015 at 3:07 pm
@@PROCID
Returns the object identifier (ID) of the current Transact-SQL module. A Transact-SQL module can be a stored procedure, user-defined function, or trigger.
https://msdn.microsoft.com/en-us/library/ms174408(v=sql.105).aspx
So this should work:
object_name( @@procid )
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 9, 2015 at 2:27 pm
Viewing 15 posts - 3,301 through 3,315 (of 6,041 total)