Viewing 15 posts - 2,701 through 2,715 (of 5,841 total)
ratheesh4sql (3/2/2013)
Thank you very much for your reply....
Using the Ola.Hallengren.com scipts..am not able to take the full backup of my Always on Seconday database.
Can u suggest me to schedule...
March 2, 2013 at 8:14 am
You have known me long enough Jeff to know I wouldn't run that test into SSMS output! 😉
My laptop being so powerful has actually forced me to do...
March 2, 2013 at 8:09 am
I recommend against using statistics time on to capture timing metrics too.
March 1, 2013 at 4:26 pm
Jeff Moden (3/1/2013)
TheSQLGuru (2/28/2013)
March 1, 2013 at 7:16 am
ratheesh4sql (3/1/2013)
Can u anyone suggest me for best practice maintenance task in sql server 2012.
I am planning to do the following in my Always on server- Production database.
1. Full...
March 1, 2013 at 6:57 am
ApexSQL and Red-Gate both have very good schema (and data) change management products. I there are some free alternatives out there but in this case believe you get what...
March 1, 2013 at 6:23 am
GilaMonster (1/31/2013)
There isn't a magic bullet. You need to sit down and tune the queries. If you have no idea where to start, consider hiring someone who does.
This thread has...
March 1, 2013 at 6:22 am
Zeal-DBA (2/27/2013)
in ma current configuration i have one data file and one log file of a tempdb database.
as a process of tempdb optimization i am going to add 16 Data...
February 28, 2013 at 12:26 pm
Lynn Pettis (2/28/2013)
Comes down to if the scalar function is being called once per query or once per row in the query.
There really is more to it than just the...
February 28, 2013 at 10:25 am
Alan.B (2/28/2013)
Jeff Moden (2/25/2013)
Alan.B (2/25/2013)
If i am understand right. Function can return only one value. am i right?
Scalar functions return one value, table valued functions return a table variable.
Inline...
February 28, 2013 at 10:12 am
A few guesses (based on very limited information provided and a few answered questions):
1) You have much faster IO now and it is able to "swap out data" in RAM...
February 28, 2013 at 6:22 am
. . .it about as joyous as an aggregated view calling an aggregated view.
You can do THAT TOO in SQL Server?!? Jeez, what a suck-@ss product! :w00t:
February 27, 2013 at 7:13 am
You may THINK you want to do a Scalar UDF, but you probably don't. I wrote a chapter for the SQL Server MVP Deep Dives 2 book entitled "Death...
February 27, 2013 at 6:33 am
1) Your server would likely die a horrible death if you set up replication on 500 databases, unless they were mostly read-only.
2) Likewise for database mirroring (even asynchronous).
3) I built...
February 27, 2013 at 6:30 am
recommendations:
1) see here:
http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx
Note there are 2 additional parts to this blog series.
2) as someone else said, you will likely need to batch up the DELETE.
3) you...
February 27, 2013 at 6:20 am
Viewing 15 posts - 2,701 through 2,715 (of 5,841 total)