Viewing 15 posts - 781 through 795 (of 901 total)
A quick Question in SQL 2008 doesnt the OPTION(RECOMPILE) on a query force that query to recompile its plan based on the values thus eliminating the need for Parameter Sniffing?
Is...
February 7, 2012 at 7:22 am
Binary checksums are ok but they have thier limitations, asan Example if a Decimal number changes by a factor of 10m, eg 100.00 to 10.00 you will get the same...
February 7, 2012 at 7:01 am
I'm not a Reg ex specialist either, and normally only resort to using them when the need is desperate.
February 6, 2012 at 8:40 am
It is possbible but needs to use a regular expresion, so you could code the the select as follows
select #temp.alunos_id, #groups.ID
from #temp
left join...
February 6, 2012 at 8:28 am
Looking at the Data you have a Leading Space infront of all numbers but that isnt replicated on the Select.
so when looking for 565, you are trying to match ',565,'...
February 6, 2012 at 8:06 am
kramaswamy (1/23/2012)
January 23, 2012 at 7:02 am
sixthzenz (1/23/2012)
January 23, 2012 at 6:37 am
A very nice article, though isnt there a better way of building the Column lists than using an XML?
Could you not just do this
Declare @var varchar(2000) = ''
Select @var=@var+','+COLUMN_NAME
from...
January 23, 2012 at 4:54 am
Sorry its my fault I type things as I'm thinking, and a common fault of mine is during table creation scripts where I think the word AS and then type...
October 10, 2011 at 6:55 am
This should work
CREATE TABLE #temp (
Item As...
October 7, 2011 at 9:01 am
Any chance you could provide the code for the temp table method you're suggestion as I'm always looking for alternatives to existing methods.
October 7, 2011 at 7:38 am
Performace Guard (Shehap) (10/7/2011)
However if the DIffs table contain quite much data entity ,then just we would dispense...
October 7, 2011 at 7:20 am
I agree, though I dont think you can do that as its not just the rows that have values against them, you have to sum up all the previous ones.
Edit...
October 7, 2011 at 4:43 am
The code sample in this link should help. http://www.codeproject.com/KB/database/splitparameterstring.aspx%5B/url%5D
The only difference is that instead of using a comma seperated list you use a # delimiter.
One minor tweak...
October 7, 2011 at 3:42 am
something like this should work, it may need some twekaing for large data sets.
CREATE Table #vals (dt DateTime, val int)
Create table #diff (dt DateTime, diff Int)
Insert into #vals
VALUES ('1-JAN-2012', 2)
Insert...
October 7, 2011 at 3:39 am
Viewing 15 posts - 781 through 795 (of 901 total)