Viewing 15 posts - 2,011 through 2,025 (of 5,843 total)
It is either a bug or "by design" (that happens to be a bad design). Check Connect for similar issues. Post one if don't find it.
May 23, 2014 at 9:36 am
Lempster (5/23/2014)
Microsoft always used to state that one should only apply a particular CU if one or more issues addressed by that CU were being experienced...pretty much in line with...
May 23, 2014 at 9:21 am
sql-lover (5/23/2014)
pgmoschetti (5/23/2014)
TheSQLGuru (5/23/2014)
.... assuming you don't make the secondary readable, which can do nasty things, including to your primary database ....
Unfortunately operators have the option to query...
May 23, 2014 at 8:37 am
Sean Lange (5/23/2014)
Can you post your sample data in a consumable format? Create table and insert statements.
Agreed. First off I don't open stuff other than query plans and text...
May 23, 2014 at 8:35 am
Plenty of good tips here. I would like to add mine, at least, what I've seen from my Developers.
If the temp table does not need Indexes, don't create any for...
May 23, 2014 at 8:34 am
pgmoschetti (5/23/2014)
TheSQLGuru (5/22/2014)
One would figure that there is a high probability that real-or-near-real-time data transfer was required or they would not have used Sync Framework in the first place. ...
May 23, 2014 at 7:11 am
1)
...
Our usual policy is to stay at the latest service pack and not apply CUs unless there is a specific fix we need. I would need to gather more...
May 23, 2014 at 7:04 am
ballooning, reservations, hard-force memory request.
Build 3000 is a BAD place to be on SQL 2012. Windows installer can keep running and failing indefinitely, using resources. Worse...
May 22, 2014 at 8:24 pm
The logging can be a big deal, although tempdb has some special optimizations for tlog stuff.
Another reason though to do the SELECT ... INTO is that come SQL 2014 that...
May 22, 2014 at 8:21 pm
I don't know of any, although I imagine there are. But any benchmarks you find should be nothing more than a rough guestimate for you. There are umpteen...
May 22, 2014 at 10:35 am
James Lean (5/22/2014)
The Page...
May 22, 2014 at 10:33 am
srikantmeister (5/22/2014)
if your second DB is standby. you can also refer log shipping or transaction replication as per your current setup
One would figure that there is a high probability that...
May 22, 2014 at 10:31 am
Matt Crowley (5/21/2014)
As an alternative to Profiler, would the data in sys.dm_exec_query_stats be a better way to get at whether certain queries/stores procs are suddenly getting worse plans? I...
May 22, 2014 at 10:28 am
sql-lover (5/21/2014)
pgmoschetti (5/21/2014)
TheSQLGuru (5/21/2014)
May 21, 2014 at 12:52 pm
I agree that synchronous database mirroring is probably the way to go here. Decent hardware should be able to keep up with 30 actions per second without much issue....
May 21, 2014 at 8:01 am
Viewing 15 posts - 2,011 through 2,025 (of 5,843 total)