Viewing 15 posts - 121 through 135 (of 610 total)
Notepad++ and MS Office at work. At home it's Miicrosoft's OneNote using OneDrive to sync seamlessly between desktop, laptop and windows phone. I can scan or find on the web...
October 27, 2014 at 2:23 am
katland226 you might hate stored procedures now and I hope one day you will understand them and favour them in your development as I do, but I also hope you...
October 23, 2014 at 3:33 am
Many people don't realise that you can just open up management studio (sql server 2008 onwards), select your server, select databases and right click the column headings to choose which...
October 23, 2014 at 3:12 am
I see only "JOIN" so that's INNER JOINs on all your tables i.e. if one is missing a record then nothing returns for that whole output row.
I would use...
October 15, 2014 at 3:45 am
convert(datetime, substring(replace(MANUFACTURED_DATE,'/',''),5,2) +
substring(replace(MANUFACTURED_DATE,'/',''),3,2) + substring(replace(MANUFACTURED_DATE,'/',''),1,2),112)
That's just so unnecessary - read the Books online entry for convert. (tip: highlight the word convert in your query in management studio and press...
October 9, 2014 at 1:07 am
Ah, you need to learn the tool controls. It's an "easy when you know how" thing.
Above those three in the report data window is a New dropdown.
Choose new datasource....
October 6, 2014 at 1:58 am
why not just back it up on 2005 and restore it on 2008?
create any sql logins on the 2008 server and relink the orphaned users
and while you're at it...
October 6, 2014 at 1:47 am
crussell-931424 (10/2/2014)
Hearing the word Final makes me realize how far behind I really am.
We're still trying to UPgrade databases onto SQL Server 2008!
October 3, 2014 at 1:30 am
We're still concentrating on getting everything up to 2008 and consolidating servers onto windows 2008R2 with plenty of virtualisation.
I don't think 2014 has had UK government security sign off...
September 19, 2014 at 4:42 am
I've rewritten some of our report writers' cursor queries lately, mainly thanks to going on Itzik Ben-Gan's Advanced T-SQL course last year and reading his Inside SQL Server 2008 T-SQL...
September 19, 2014 at 1:22 am
Jeff Moden (9/17/2014)
P Jones (9/17/2014)
...and wait until it is fully available ....
I'm curious. What are you using to determine that a file is done being written to and is...
September 19, 2014 at 12:59 am
SSIS can also do this well along with SQL Agent to run the SSIS package. Either waiting for a file to appear in a folder or running at specified times...
September 17, 2014 at 1:15 am
CTEs are just so much more elegant and readable and easier to test each step - I've ended up with 6 in one query to build up data and do...
September 16, 2014 at 1:36 am
It's all so very "big company".
In a smaller outfit like this with only half a dozen in the dev team covering DBA, design, development and day-to-day application support, you...
July 23, 2014 at 2:54 am
Grins and nods - been there! SSRS multiselect can be a real pain, especially with string parameters.
Which is why our report writers insist on having Jeff Moden's DelimitedSplit8K [/url] and...
July 14, 2014 at 1:33 am
Viewing 15 posts - 121 through 135 (of 610 total)