Viewing 15 posts - 211 through 225 (of 1,957 total)
Can you guarantee the format of that data will be consistent?
For example, will you ever see "1.Oz." (no spaces) or "1.. Oz." or " 1 Oz"?
July 28, 2015 at 5:32 pm
As long as you are using a single # before the temp table name, they will be isolated without any intervention on your part.
If you use two ## before the...
July 28, 2015 at 5:28 pm
It could well be down to bad estimates.
According to this White Paper: Statistics Used by the Query Optimizer in Microsoft SQL Server 2008, when you use local variables,
If you...
July 28, 2015 at 5:26 pm
One way round this sort of problem is to declare your parameter as longer than the you want to allow, then test the length to see if it is going...
July 22, 2015 at 1:06 pm
Use stored procedures for CRUD operations, and include code in there to update the header.
The problem I have with triggers, is that people/tools don't always remember to check for them...
July 17, 2015 at 6:04 pm
Jeff Moden (7/13/2015)
However it does belong in the db, and there are valid cases for it. I might have data like this list of books, perhaps it's old data and...
July 13, 2015 at 6:29 pm
Jeff Moden (7/13/2015)
July 13, 2015 at 6:11 pm
Could be parameter sniffing, so please read this: Catch-all queries[/url]
Could be different settings on the connection (not the conn.string), try capturing the execution plan for the SSRS run and compare...
July 9, 2015 at 1:12 pm
faulknerwilliam2 (7/6/2015)
A date field in a report returns the date value as:
2015-07-01 13:30:27.000
Is there any way I can script this to appear as:
01 July 2015 (or 01-07-2015 or 01/07/2015) ...
July 6, 2015 at 4:17 pm
OK, let's try another way.
Open regedit (usual rules apply - don't change anything) and navigate to:
HKEY_CURRENT_USER\SOFTWARE\Microsoft\SQL Server Management Studio\XX.0\Packages (where XX is your version number - I think 2014 is...
July 6, 2015 at 1:51 pm
abatej (7/6/2015)
July 6, 2015 at 7:36 am
Eric M Russell (7/2/2015)
SSMS might not have a future without AddIns for stuff like object searching and T-SQL formatting. Every release of SSMS should come bundled with a starter project,...
July 2, 2015 at 2:05 pm
mister.magoo (7/1/2015)
**WARNING** Make sure you...
July 1, 2015 at 4:10 pm
Don't bother looking in that file, it will only tell you the same thing - that the package failed to load.
You have installed a Visual Studio extension package (it may...
July 1, 2015 at 1:20 pm
Ed Elliott (6/30/2015)
That sounds awesome, are you going to share it?
Been thinking about it, but not yet.
I might stick it on github at some point, but it's not production ready...
June 30, 2015 at 4:50 am
Viewing 15 posts - 211 through 225 (of 1,957 total)