Viewing 15 posts - 1 through 15 (of 172 total)
Sorry for being unclear.
I performed the restores using SSMS-GUI the 2nd restorei checked the 'Overwrite the existing database(with replace)'.
November 27, 2019 at 4:11 pm
Ex.
Typing 'Select * from MyTable..' in SSMS SqlPrompt then brings up a list of tables fitting that spelling.
Using arrow key down to go to specific table.
At...
October 15, 2015 at 7:20 am
I am a huge fan of Sql Prompt. Prior it seemed i would manage to memorize most of the database for quick querying.
Do you know of a method to...
October 14, 2015 at 7:43 am
I understand now that this is newID() functionality.
I am familiar with using CTEs for recursion for ',' delimiting and see the difference. It just sorta, kinda, maybe...
August 4, 2015 at 1:19 pm
Original Expected results were lines 1 - 3 (key: PO1, 11, 2015/07/25) have one GUID and Line 4 (key po1, 11, 2015/07/26) have a different GUID.
Using the cteReceiveGuid for...
August 4, 2015 at 1:07 pm
I have never had a Truncate issue so I would start at the select into.
a) How much space is available for the database? Was the delay caused by...
January 30, 2014 at 12:50 pm
I went to 2012 SSMS without any 2012 databases.
The Visual Studio-isk ability to pull files onto different monitors feature was worth the update by itself.
November 21, 2013 at 9:05 am
That was my thought direction also.
One idea
During the insert since the non-clustered index (includes) is also being created/populated, swapping out the PKEY index would be removing overhead and would be...
November 18, 2011 at 9:16 am
I understand the value of a clustered index.
I was questioning whether switching from a clustered index on an Identity to a clustered index on non-sequential keys would affect performance of...
November 18, 2011 at 8:44 am
Thanks for the location of the Sql2008 SqlServer2005_bc.msi file. Worked like a charm!
My test database on prod database (3rd party app) are not running on the same OS. ...
November 8, 2011 at 1:08 pm
I think somebody has a faulty memory. When I run against Sql2000 and sql2008 I get the same results from your sample.
projectidapCountarCount
A22
B33
C20
projectidapCountarCount
A12
B13
C20
Note: I did run both from Sql2008 SSMS...
August 12, 2011 at 9:34 am
Create a function that takes a comma delimited sting and returns a two column table. (ID, LookupValue)
Select yada
FROM MyTable
Left Join fnc_tableFromString(@argMyString) theName ON myTable.name = theName.name
where myTable.id is null
August 11, 2011 at 2:02 pm
create proc YourProc
@arg1 varchar(25) = null
as
set nocount on
select * from mytable
where (@arg1 is null or mytable.mycolumn = @arg1)
August 4, 2011 at 12:19 pm
Nice snippet Lowell.
That looks like a nice piece of code to place in the tool chest!
July 20, 2011 at 11:49 am
Viewing 15 posts - 1 through 15 (of 172 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