Viewing 15 posts - 91 through 105 (of 1,790 total)
You might want to configure a trace to run in the background that logs expensive activity, i.e. high reads > 100,000, high CPU > 10,000, high duration > 15,000 (those...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 26, 2012 at 9:41 am
No, I would highly doubt that the creation of the index + the copy would take as long as without the index and allowing the copy to continue. However, you...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 26, 2012 at 7:49 am
aaron.reese (4/26/2012)
I have a table with 110M rows in it, 33 fields per row, mostly varchars of varing lengths with no clustered index (20GB)
I am copying the table to...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 26, 2012 at 7:41 am
I can't say that I would use it for extensive work but if I needed to deal with an alert quickly or run a quick query I might use one....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 20, 2012 at 12:21 pm
You would need to write an application wherein you can establish a connection and use it for several processes. I did a quick Google search on "introduction to connection pooling"...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 20, 2012 at 6:32 am
+1 on Michelle's scripts. This script allows for you to evaluate the index fragmentation and then, through passed in parameters, choose which...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 18, 2012 at 8:21 am
You can also use Ola Hallengren's script for backups which will cover all or select databases.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 18, 2012 at 8:15 am
Ah - I still remember the SQL Server on Linux joke. Have to admit it had some ideas racing in my mind. 😛
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 2, 2012 at 12:00 pm
Tony Davis (4/1/2012)
If it turns out I'm the only one who was initially unaware of the "safety checks" that use of REPLACE disables then we can all move on :-).
Uh,...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
April 2, 2012 at 9:33 am
Your analysis is going to have to include a look at what is going on at the disk layer as well, i.e. what is the disk latency during that time....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 30, 2012 at 2:46 pm
No, you weren't coming off as arrogant. My apologies if my reply, specifically the statement about humility, seemed that I was implying such. 🙂
What you stated is really my point,...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 29, 2012 at 1:08 pm
There are times that I think I know a good bit about SQL Server and then I go to work somewhere that they use it in a different fashion than...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 29, 2012 at 12:54 pm
Steve Jones - SSC Editor (3/26/2012)
Choosing vendors to be partners is hard[/B]
I think the key term that needs to be considered is "partners" and even though not highlighted as a...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 27, 2012 at 7:08 am
Gianluca Sartori (3/15/2012)
Lynn Pettis (3/14/2012)
GilaMonster (3/14/2012)
Koen Verbeeck (3/14/2012)
Gianluca Sartori (3/14/2012)
Back on topic, yes, they definitely are: http://www.sqlservercentral.com/Forums/FindPost1266924.aspxI actually laughed out loud.
Well it's one of our old friends, so are you...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 15, 2012 at 6:59 am
gmcrouch (3/7/2012)
get several event 833 errors in app log (IO request taking longer then 15 seconds)
That screams IO subsystem problem. 🙁
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 7, 2012 at 12:49 pm
Viewing 15 posts - 91 through 105 (of 1,790 total)