Viewing 15 posts - 181 through 195 (of 5,590 total)
Going to SIMPLE recovery model first can sometimes make it easier to shrink the transaction log as small as possible. Going to SIMPLE is never my first choice... I try...
October 2, 2015 at 11:50 am
Michael L John (10/2/2015)
SQLRNNR (10/1/2015)
Ed Wagner (10/1/2015)
If...
October 2, 2015 at 11:42 am
mw112009 (10/2/2015)
1.) Remove the DISTINCT ... Why ? The UNION operator always will return the distinct rows. I ran a...
October 2, 2015 at 11:38 am
mw112009 (10/1/2015)
I pressed the "Display estimated execution plan " but it did not tell me to create any new indexes.
Please be very careful with this. Just looking for missing indexes...
October 2, 2015 at 11:26 am
mw112009 (10/2/2015)
Also the hinstp has only 479...
October 2, 2015 at 11:19 am
mw112009 (10/2/2015)
I have attached the stored proc code...
The entire stored proc gets run under 3 seconds.. I am in...
October 2, 2015 at 9:56 am
CptCrusty1 (10/2/2015)
The exec staff got involved in this. Yet another proc showed up that "just did xyz" and they decided they'd had enough. The person...
October 2, 2015 at 9:41 am
mw112009 (10/2/2015)
Tried to upload file several times and it fails ( Upload about 65% and after that the web page in the small window breaks )
Can you put it...
October 2, 2015 at 8:53 am
mw112009 (10/2/2015)
I have the following index defined on hinstp table covering 2 columns ( ADMDT, FORMN )
PK_HINSTPclustered, unique, primary key located on...
October 2, 2015 at 8:51 am
ben.brugman (10/2/2015)
WayneS (10/1/2015)
The quickest, most sure-fire way to reduce the code would be to use CTRL+A followed by CTRL+X. :w00t::w00t:
Good anwser.
I would like to make a little change.
Maybe it...
October 2, 2015 at 8:36 am
WADRIAN68 (10/2/2015)
That's beautiful, Thank you!
I've also learnt something as I had no idea the LAG function existed. I've replicated the concept into my actual scenario and am...
October 2, 2015 at 8:25 am
Lynn Pettis (10/2/2015)
I love the code that looks like this:WHERE ISNULL(SomeColumn,'') > ''
What I love is when SomeColumn is defined as NOT NULL
October 2, 2015 at 8:17 am
Lynn Pettis (10/1/2015)
In my Deadlock thread, was I wrong to admonish the former MVP over his first post? It just hit me wrong.
I thought so... the first sentence is...
October 2, 2015 at 8:15 am
Ed Wagner (9/29/2015)
October 1, 2015 at 4:55 pm
If I understand your requirements correctly, I think that this will do the job.
Since you posted in a SQL 2012 forum, I used features available in 2012.
DECLARE @MockData TABLE...
October 1, 2015 at 4:29 pm
Viewing 15 posts - 181 through 195 (of 5,590 total)