Viewing 15 posts - 4,081 through 4,095 (of 6,035 total)
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...
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...
March 9, 2015 at 7:33 am
sqlcentral.dah328 (3/5/2015)
sql-lover (3/5/2015)
sqlcentral.dah328 (3/4/2015)
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...
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...
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()...
March 4, 2015 at 11:36 am
Peter Schott (3/4/2015)
Eric M Russell (3/4/2015)
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...
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...
March 4, 2015 at 11:04 am
There are some 3rd part applications, for example employee project / time reporting or asset management, that require SQL Server as database but are relatively small scale and don't require...
March 3, 2015 at 11:27 am
At least for me, schema comparison is more of a diagnostic tool used in scenarios where I'm troubleshooting an issue in production and need to know what total differences there...
March 3, 2015 at 9:14 am
Bob JH Cullen (3/3/2015)
Eric M Russell (3/3/2015)
March 3, 2015 at 9:05 am
It sounds to me like some folks are just making in-place modifications to tables and stored procedures in the development environment and then using a schema compare against production too...
March 3, 2015 at 8:43 am
ZZartin (3/2/2015)
Jeff Moden (3/2/2015)
Don Halloran (3/1/2015)
(Also I hate web development 😛 )
Ah, yeah... we need to you move that smiley face one pixel to the right and change the color...
March 3, 2015 at 7:27 am
Migrations based deployments are based on tracking each change to a database in a separate script and then executing each script, in order, on your production database. This is hard...
March 2, 2015 at 12:20 pm
Viewing 15 posts - 4,081 through 4,095 (of 6,035 total)