Viewing 15 posts - 3,451 through 3,465 (of 6,041 total)
First, consider giving surrogate key identifiers a unique names, and a broadly used standard is to use <tablename>ID (ie: MessageID instead of just ID). I'd recommend making this...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 17, 2015 at 1:50 pm
You can leverage the INFORMATION_SCHEMA.COLUMNS system table, which contains one row for each table and column in the database, to build up a SQL select statement into a variable.
To execute...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 17, 2015 at 12:41 pm
Sean Lange (9/17/2015)
Eric M Russell (9/17/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 17, 2015 at 9:47 am
Someone had mentioned that the date/time conversions can be expensive. Depending on what you're needing to do with the dates and times once they're converted, it might make sense just...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 17, 2015 at 7:47 am
Whether a Jet based database will scale up to 1 TB depends on how exactly you are partitioning and the case usage of how the users are querying it. Jet...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 16, 2015 at 3:30 pm
Jeff Moden (9/4/2015)
Alvin Ramard (9/4/2015)
Jeff Moden (9/3/2015)
sriponraj (9/3/2015)
Check the connection for temp db by using sp_who2 active. Kill all the connection related to temp db and try to shrink..
So, if...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 4, 2015 at 8:48 am
Andrew_Steitz (9/4/2015)
Ed Wagner (9/3/2015)
Jeff Moden (9/3/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 4, 2015 at 8:45 am
If this is a reporting database with stored procedures that typically run for several minutes or longer, then one thing I do to audit usage and performance is implement something...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 4, 2015 at 8:31 am
To decode the actual reason the login failed, you'll have to look in error log (not client message) for the State code.
http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx
Note that the message is kept fairly nondescript to...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 3, 2015 at 3:16 pm
xinternet (9/3/2015)
SQL2005 is EOF April 2016. It's on Extended Support. So not accurate to say "... old, unsupported ..."
For a TB+ sized data warehouse there is more of...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 3, 2015 at 2:53 pm
Andrew..Peterson (9/3/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 3, 2015 at 9:35 am
bwhiteside (9/3/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 3, 2015 at 9:07 am
jckfla (9/3/2015)
Eric M Russell (9/2/2015)
Psst! Hey Buddy! You wanna buy some source code?
Yuck, who let a sales repsentative for Red Hat wander into the data center? 😀
Oh dear...I feel...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 3, 2015 at 8:53 am
Alvin Ramard (9/3/2015)
Eric M Russell (9/3/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 3, 2015 at 8:50 am
ccd3000 (9/3/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
September 3, 2015 at 8:47 am
Viewing 15 posts - 3,451 through 3,465 (of 6,041 total)