Viewing 15 posts - 2,161 through 2,175 (of 6,041 total)
In all fairness, it would be useful on occasion to have a feature, let's call it "Delayed Consistency", allowing one to perform multiple DML operations within an batch transaction, perhaps...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 12, 2016 at 1:06 pm
Compare the execution plan between the two servers for an identical query using same parameters.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 12, 2016 at 7:50 am
If this ID is a sequential integer, then use IDENTITY.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 12, 2016 at 7:25 am
Ask yourself whether some of these cost and price related columns should really be attributes in a dimension, not measures on a fact table.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 12, 2016 at 6:21 am
To block all readers suring your insert operation, either the TABLOCK or TABLOCKX hint will work.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 11, 2016 at 11:39 am
If developers struggle to install and manage SQL Server on their local PC, imagine if they were left to manage the production database server? I guess it's like a DBA...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 11, 2016 at 10:06 am
Hi Andy,
Let me run this past you.
So, the problem as I understand it is that we really don't need to be informed 1,000,000 times that (for example) an ETL...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 11, 2016 at 8:05 am
First, I'll turn on the radio to NPR news (I hate political\entertainment talk radio and morning rock DJs shows). If there isn't a good feature on, then I'll switch over...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 10, 2016 at 10:46 am
First thing, use a schema comparsion tool to confirm that all the indexes and code changes existing in development have been deployed to production.
Microsoft SQL Server Data Tools
https://msdn.microsoft.com/en-us/library/hh272690(v=vs.103).aspx
Open DBDiff
http://opendbdiff.codeplex.com/
RedGate SQL...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 7, 2016 at 8:49 am
How many databases does each DBA in your organization manage?
Ha! That's a trick question.
If you had asked how many database servers, then I could give you a total number...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 7, 2016 at 7:05 am
Jeff Moden (10/5/2016)
komal145 (10/5/2016)
i have check other tables and do lot of stuff to get this point . So , i have to do it in ssis.
Not really. ...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 6, 2016 at 9:21 am
Maybe for an ISV, you have a group of developers who are always focussed on new development and then another team that does primarily maintenance and enhancement. However, everywhere I've...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 6, 2016 at 9:11 am
I'd also mention the issue of page splitting, fragmentation, fill factor, and how it all relates to choosing the optimal clustering key combination.
https://sqlperformance.com/2015/04/sql-indexes/mitigating-index-fragmentation
Imagine you're stacking books on a shelf sorted...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 6, 2016 at 7:06 am
Like today, within SSMS Object Explorer, you can right click on a stored procedure, table, view, etc. and select 'View Dependencies'.
Still there are occasions where it's useful to query...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 5, 2016 at 9:51 am
Phil Parkin (10/5/2016)
If there is one feature I'd love to see added is the ability to stronly type worksheet columns, meaning for example that all values within a column would...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 5, 2016 at 8:41 am
Viewing 15 posts - 2,161 through 2,175 (of 6,041 total)