Viewing 15 posts - 1,636 through 1,650 (of 5,843 total)
gaojia2004 (2/9/2015)
TheSQLGuru (2/4/2015)
February 9, 2015 at 5:54 am
I think there was a link to an Aaron Bertrand post about MERGE issues. Do a web search for "sql server merge concurrency problem" and you will get a...
February 6, 2015 at 2:44 pm
MERGE is buggy (still), still subject to race/concurrency issues and you should try it with triggers on the target table sometime ...
February 6, 2015 at 12:48 pm
You can do this using the Import Data Wizard (SSMS Object Browser, right-click a Database, Tasks, Import Data...). From there you can save it off as an SSIS package...
February 6, 2015 at 10:44 am
Since you mentioned Maintenance Plan let me once again plug Ola.Hallengren.com's AWESOME, FREE, DOCUMENTED and SUPPORTED maintenance suite. Get it, learn it, use it!! 😎
February 6, 2015 at 10:42 am
Try this at your own risk. I have used it in the past, but pretty sure it was for single-file/filegroup databases and they didn't have filestream.
drop table #files
drop table...
February 6, 2015 at 8:25 am
Not sure - I haven't had to install it for some time now.
February 5, 2015 at 4:34 pm
So you aren't reading significant data, you have a config issue limiting memory usage or you aren't monitoring correctly in vSphere. Those are the only 3 options that I...
February 5, 2015 at 3:37 pm
1) what is max memory setting in SQL Server?
2) SQL Server buffer pool will use all memory available to it up to the max mem setting. If queries are...
February 5, 2015 at 3:01 pm
1) I think I would give the OS and other stuff more than 7GB of memory.
2) I would run a differential analysis of wait stats. capture them into a...
February 5, 2015 at 2:51 pm
What size data is being accessed? If you have (or only access) small amounts of data then SQL Server will not acquire more memory than it needs.
Try dbcc memorystatus...
February 5, 2015 at 2:47 pm
I'm not feeling very well (especially mentally) right now, but after upgrading to 2012 can't you do a new FULL backup and restore that to the secondary and start rolling...
February 4, 2015 at 3:03 pm
Until you mentioned it I had never heard of Zabbix. That isn't a good sign for you BTW, as I have been dealing with SQL Server for ~20 years....
February 4, 2015 at 2:56 pm
Please provide create table statements, insert statements and sample expected data so we can help you. Assuming you have a UNIQUE key for each row between the two systems...
February 4, 2015 at 12:58 pm
You can get Tim Ford/Louis Davidson's free performance tuning with DMVs book. Glenn Berry's SQL Server Diagnostics Scripts. sp_whoisactive. Do your own file IO stall and wait...
February 3, 2015 at 7:09 pm
Viewing 15 posts - 1,636 through 1,650 (of 5,843 total)