Viewing 15 posts - 5,311 through 5,325 (of 8,761 total)
i1888 (5/14/2015)
We have a client in another country, I have asked them to send me the full backup in a usb, and upload ongoing log files via SFTP, something weird...
May 14, 2015 at 9:45 pm
Looks like a healthy piece of kit you got there, first question is how these numbers compare to what it says on the box, for a mid range SAN this...
May 14, 2015 at 1:54 pm
orman.ionut (5/14/2015)
Is it possible to determine the data flow within a database? e.g. I start by adding/inserting a record in MainTable1, then through a trigger SubTable1, SubTable2...
May 14, 2015 at 1:45 pm
Just to pile on a bit, use the desired collation to get the desired sort order
😎
Collation example with Lowell's data sample:
use tempdb;
go
;WITH MyCTE([ColumnName])
AS
(
SELECT N'000000000000001' UNION ALL
SELECT N'000000000000005' UNION ALL
SELECT N'000000000000006'...
May 14, 2015 at 1:39 pm
SQL Guy's suggestion is good, only concern would be how the DBAs are going to react with all the verbosity unless you filter the result set.
😎
May 14, 2015 at 12:54 pm
TomThomson (5/14/2015)
crookj (5/13/2015)
Ed Wagner (5/13/2015)
DonlSimpson (5/13/2015)
BabyGirl
Grand-Daughter (my 2nd was born 8 days ago)
Congratulations
Wishes
May 14, 2015 at 12:33 pm
Revenant (5/14/2015)
Ed Wagner (5/14/2015)
crookj (5/14/2015)
Ed Wagner (5/14/2015)
djj (5/14/2015)
Ed Wagner (5/13/2015)
SQLRNNR (5/13/2015)
djj (5/12/2015)
Ed Wagner (5/12/2015)
Revenant (5/12/2015)
SQLRNNR (5/12/2015)
djj (5/12/2015)
BWFC (5/12/2015)
SQLRNNR (5/12/2015)
whereisSQL? (5/12/2015)
BWFC (5/12/2015)
Intelligence
Business
Oxymoron
Subjective
Objective
Lens
Magnify
Quantify
Numbers
Meaning
Life
Curly (City Slickers)
Cowboy
Steer
Tenderloin
Tipping (cow)
Canoe
Canada
Caesium
May 14, 2015 at 11:57 am
GilaMonster (5/14/2015)
Over the years I've been very careful to keep my blog completely non-commercial, no adverts, no plugs for my company, nothing. Partially because when I...
May 14, 2015 at 11:52 am
There are few ways of doing this, my guess is that you are not close to any of them but in order to help you find an acceptable solution, you...
May 14, 2015 at 11:48 am
kranp (5/14/2015)
I am logged in sql as 'dw' login.When I execute the stored proc
EXEC br_********Data
Error:
Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'br_********Data'.
Must repeat Lynn's...
May 14, 2015 at 11:41 am
Steve Jones - SSC Editor (5/12/2015)
May 13, 2015 at 12:44 pm
crookj (5/13/2015)
djj (5/13/2015)
Ed Wagner (5/13/2015)
DonlSimpson (5/12/2015)
TomThomson (5/12/2015)
Ed Wagner (5/12/2015)
Eirikur Eiriksson (5/12/2015)
djj (5/12/2015)
Ed Wagner (5/12/2015)
Revenant (5/12/2015)
SQLRNNR (5/12/2015)
djj (5/12/2015)
BWFC (5/12/2015)
SQLRNNR (5/12/2015)
whereisSQL? (5/12/2015)
BWFC (5/12/2015)
Intelligence
Business
Oxymoron
Subjective
Objective
Lens
Magnify
Quantify
Numbers
Meaning
Life
Cycle
Circle
Ring
Nazgûl
Middle Earth
Tree
barrow-wight
Ghost
May 13, 2015 at 7:20 am
djj (5/12/2015)
Ed Wagner (5/12/2015)
Revenant (5/12/2015)
SQLRNNR (5/12/2015)
djj (5/12/2015)
BWFC (5/12/2015)
SQLRNNR (5/12/2015)
whereisSQL? (5/12/2015)
BWFC (5/12/2015)
Intelligence
Business
Oxymoron
Subjective
Objective
Lens
Magnify
Quantify
Numbers
Meaning
Life
Cycle
May 12, 2015 at 1:54 pm
Eric M Russell (5/12/2015)
May 12, 2015 at 1:54 pm
Bill Talada (5/11/2015)
Eirikur Eiriksson (5/11/2015)
Bill Talada (5/11/2015)
May 11, 2015 at 3:28 pm
Viewing 15 posts - 5,311 through 5,325 (of 8,761 total)