Viewing 15 posts - 241 through 255 (of 627 total)
I just bought a brand new F-150 last week and I'm so pumped. Can't wait to get my hands on it (still waiting on delivery). Been wanting a...
July 11, 2016 at 8:19 am
If you are worried about locking a table when deleting a lot of rows you could delete in batches. As far as actual delete speed just make sure you...
July 5, 2016 at 1:51 pm
Ed Wagner (7/5/2016)
ThomasRushton (7/5/2016)
Stuart Davies (7/5/2016)
ClubKitkat
Candy
Cane
July 5, 2016 at 8:01 am
Manic Star (6/30/2016)
ZZartin (6/30/2016)
Luis Cazares (6/30/2016)
Ed Wagner (6/30/2016)
Manic Star (6/30/2016)
Grumpy DBA (6/30/2016)
Ed Wagner (6/30/2016)
RaceRat
Tail
Head
Body
Site
Downtime
Relaxing
June 30, 2016 at 8:56 am
Charmer (6/29/2016)
I am getting different values for DatabaseName, ReportID on same date.I want to show both values. But pivot choose max value.
Possible to handle this?
Do you mean to say that...
June 30, 2016 at 7:57 am
durga.palepu (6/28/2016)
Yet another good alternative to learn but little complex compared to pivot solution.
Actually only the dynamic aspect makes it seem complicated which would also hold true if built with...
June 28, 2016 at 2:09 pm
djj (6/28/2016)
Ed Wagner (6/28/2016)
Ray K (6/28/2016)
crookj (6/28/2016)
eccentricDBA (6/28/2016)
Luis Cazares (6/28/2016)
Ed Wagner (6/28/2016)
Grumpy DBA (6/28/2016)
ThomasRushton (6/28/2016)
Ed Wagner (6/28/2016)
RedRum
Shining
Johnny
Bravo
Tango
Foxtrot
Whisky
Delta
Dawn
Dusk
June 28, 2016 at 8:13 am
Since I was already working on it here is a dynamic crosstab example Jeff was talking about.
DECLARE @Actual TABLE (ReportDate date , DatabaseName varchar(10), ReportID int , TotalSum bigint )...
June 28, 2016 at 8:10 am
I would also like to say that hopefully this is for display purposes only (which could instead be handled by the client side application). Whatever you do, make sure...
June 27, 2016 at 9:54 am
Check the properties of your database and find it's Recovery Model.
Log files are automatically truncated in Simple recovery model. Otherwise if the recovery model is set to FULL or...
June 27, 2016 at 8:47 am
Excellent article! While I've had no need for this yet, I can easily see how this could come in handy one day. Added to my briefcase...looking forward to...
June 23, 2016 at 8:18 am
Ed Wagner (6/23/2016)
Grumpy DBA (6/23/2016)
Ed Wagner (6/23/2016)
PlainJane
Tarzan
Lord (of the apes)
June 23, 2016 at 7:55 am
It's not clear if your requirement is to round to the nearest hour or just round down or something else?
If you need to round down or up based on minutes...
June 23, 2016 at 7:45 am
Hugo Kornelis (6/21/2016)
Ed Wagner (6/21/2016)
Manic Star (6/21/2016)
Grumpy DBA (6/21/2016)
Ed Wagner (6/21/2016)
Luis Cazares (6/21/2016)
Revenant (6/21/2016)
Ray K (6/21/2016)
djj (6/21/2016)
RollerDerby
Hat
Sombrero
Mexico
Cartels
Tequila
Worm
Sand
Dune
June 21, 2016 at 1:43 pm
Personally I find PowerShell well suited for something like this. However, it can be a bit tricky especially if you are new to it.
June 21, 2016 at 7:20 am
Viewing 15 posts - 241 through 255 (of 627 total)