Viewing 15 posts - 6,496 through 6,510 (of 22,211 total)
stephen.long.1 (3/31/2015)
Regardless of the merits of adding semicolons at the end of all statements (something which I don't do, but...
March 31, 2015 at 8:10 am
Just not crazy about this phrasing:
Since few semicolons are used,
I use semicolons on terminators for all my statements. Everyone should.
March 31, 2015 at 7:08 am
And when you think you have a handle on the changes suggested, all good, take a look at the execution plan to understand how the optimizer is resolving the query....
March 31, 2015 at 7:06 am
What you can do is restore your database to another location and then run the full CHECKDB statement there. You really do need to do the internal logical checks as...
March 31, 2015 at 7:04 am
You may just have a long running transaction. Check to see if that process is blocked by looking at sys.dm_exec_requests.
March 31, 2015 at 7:02 am
This is the reason you're taking full backups and log backups. Restore to a point in time prior to the corruption of the database.
March 31, 2015 at 7:01 am
GilaMonster (3/31/2015)
spaghettidba (3/31/2015)
GilaMonster (3/31/2015)
Not efficient as it prevents index seeks, not that a text column can have indexes, but I don't like teaching bad options.
Exactly my point: a bad option...
March 31, 2015 at 6:57 am
jellybean (3/31/2015)
Process to up-greade to SQL Server 2014 from 2005
0. On the *separate* target box install Sql Server...
March 31, 2015 at 6:55 am
Jeff Moden (3/30/2015)
krypto69 (3/30/2015)
Long story, but it's financial data and I'm new there so can't complain..yet.
Kinda figured those were my only options. Shame I can't use my high avail...without...
March 30, 2015 at 7:35 pm
You'll have to combine that view with other functions and views to get a complete picture. You can use sys.dm_exec_sql_text to get the query and sys.dm_exec_query_plan to get the plan.
I'd...
March 30, 2015 at 6:57 pm
Why would developers need live data to develop against?
But, if you have to, the technologies you have available are somewhat limited because they will prevent changes to the database. For...
March 30, 2015 at 3:06 pm
The best way is to capture queries using extended events. You can see how much memory the query consumes. You can also look at sys.dm_exec_query_stats to see some aggregation information...
March 30, 2015 at 3:02 pm
No, the data gets updated AND the log gets written. As was stated above, this is to help maintain ACID properties and it makes it possible to do point in...
March 30, 2015 at 2:59 pm
But if you're not using differentials, you can use the secondaries for backups. Also, the log backups can, roughly, be taken anywhere and then combined later. I wrote a chapter...
March 30, 2015 at 2:56 pm
I have not done the 2005 SP4 upgrade to 2014, but, if the documentation says it supports it, it probably does.
I'd go with the first setup you have suggested there....
March 30, 2015 at 10:49 am
Viewing 15 posts - 6,496 through 6,510 (of 22,211 total)