Viewing 15 posts - 4,081 through 4,095 (of 6,041 total)
Andrew..Peterson (3/10/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 10, 2015 at 10:10 am
Disclaimer: I have no practical experience with MongoDB at this point, so if my assumptions below are wrong, then please let me know.
I can see MongoDB as an ideal...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 10, 2015 at 8:12 am
CREATE CLUSTERED INDEX IX_UNIQUE_KEY ON MRP.Margin_Optimization_Data (UNIQUE_KEY);
If IX_UNIQUE_KEY is intended to be a unique key, then you probably want to add the UNIQUE keyword.
CREATE UNIQUE CLUSTERED INDEX IX_UNIQUE_KEY
ON...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 9, 2015 at 11:49 am
DBA's arn't born cranky; it's an acquired attitude. It does seem to me that unqualified developers (at least in terms of database design) get the first crack at a new...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 9, 2015 at 9:47 am
GoofyGuy (3/9/2015)
Any suggestions for suitable descriptive words for types of database?
'Web service'.
Abstracting out the database layer from the application offers a number of advantages -- not the least of...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 9, 2015 at 9:15 am
I wish that Microsoft would put a bit more development into the SSMS Database Diagrammer tool. It's OK, for basic modeling, but it's limitations quickly become apparent when it comes...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 9, 2015 at 8:58 am
In recent versions of SQL Server, we now have a handful of table types to choose from: traditional row store, Heckaton in-memory (high volume OLTP), ColumnStore (data warehousing). Each table...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 9, 2015 at 8:47 am
I'm convinced that no more than 1 in 4 IT shops, and this includes everything from two man startups to major corporations, really just don't "get" database engineering. If you've...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 9, 2015 at 7:33 am
sqlcentral.dah328 (3/5/2015)
sql-lover (3/5/2015)
sqlcentral.dah328 (3/4/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 5, 2015 at 9:49 am
I'm assuming the goal here is the retreive the latest DUESTATUS and COMPSTATUS for each PERSID, and what we have to work with is a table containing one record for...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 5, 2015 at 8:13 am
There are a lot of scenarios where SSMS table designer or a schema compare tool will want to rename / create / select / insert, when a simple ALTER TABLE...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 4, 2015 at 1:56 pm
Looking at the SQL, it appears that PERSON doesn't contain one row per person but rather multiple rows per person for each status change. I think you can leverage row_number()...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 4, 2015 at 11:36 am
Peter Schott (3/4/2015)
Eric M Russell (3/4/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 4, 2015 at 11:30 am
I'm not sure, but with a database in SINGLE_USER mode, I think it's possible for a non-sysadmin user to login and block even the DBA, or the DBA may be...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 4, 2015 at 11:20 am
For those of you who work in shops where developers make in-place changes to database objects and deployments are based on comprehensive delta scripts, how do you implement versioned source...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 4, 2015 at 11:04 am
Viewing 15 posts - 4,081 through 4,095 (of 6,041 total)