Viewing 15 posts - 1 through 15 (of 5,394 total)
Please post table scripts, sample data and expected output. It's easy, promised 🙂See http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/ for guidance.
June 14, 2018 at 7:25 am
I suppose that you have been told to avoid taking backups with TRUNCATE_ONLY, because they break the log chain. Shrinking the log is a totally different operation, that (while potentially...
June 14, 2018 at 3:12 am
You should load a staging table with the new (id,name) pairs and then updat the target table from the staging table.Something like this:UPDATE targSET name...
July 19, 2017 at 1:46 am
First unpivot, then pivot:
IF OBJECT_ID('tempdb..#test') IS NOT NULLDROP TABLE #test;
CREATE TABLE #test( populationtypedescription varchar(10) ...
July 6, 2017 at 3:23 am
Jeff Braunstein-302643 - Wednesday, June 28, 2017 12:09 AM
Thank you for your insight, but...you understand this is a 7 year old thread, right?
June 28, 2017 at 2:09 am
April 11, 2017 at 3:18 am
April 11, 2017 at 3:13 am
March 20, 2017 at 4:49 am
SQLBrowser returns the list of instances on a machine and the protocols+protocol details of a given instance.You will need it whenever:1) You are trying to connect to a...
March 8, 2017 at 4:28 am
January 29, 2017 at 11:30 pm
January 27, 2017 at 8:14 am
It looks like the stored procedure was not created correctly.
Do not attempt to run the .sql file directly from Adam's .zip archive: extract it to a temp folder and open...
December 28, 2016 at 2:18 am
You can use my stored procedure template here: https://spaghettidba.com/2011/07/08/my-stored-procedure-code-template/
Then you just have to add the INSERT and SELECT statements that you need. Actually, with composable DML, you can achieve the...
October 28, 2016 at 12:35 am
Your description of the problem is a bit vague.
Which table will you be inserting data into? What set of parameters are you expeting? Where will the select statements pull...
October 28, 2016 at 12:07 am
Short answer: you can't.
Long answer: there is no way to tell whether a backup will restore succesfully or not and that alone is no guarantee that the backup does not...
October 17, 2016 at 3:34 am