Viewing 15 posts - 1 through 15 (of 5,393 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 targ
SET name...
July 19, 2017 at 1:46 am
First unpivot, then pivot:
IF OBJECT_ID('tempdb..#test') IS NOT NULL
DROP 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:13 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 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
Viewing 15 posts - 1 through 15 (of 5,393 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy