Monday, November 11, 2013

using random in sql for unique values

create table #tempo (id int unique identity, val varchar(100)  unique, other  varchar(1000))
insert into #tempo(val,other  )
select cast (cast(RAND() * 100000000 as int ) as varchar)    ,'fdgfggdfdfgdg'
union select cast(cast( RAND()* 100000000 as int) as varchar)   ,'fdfgdfdfgdg'
select * from #tempo
drop table #tempo

IISRESET vs Recycling Application Pools

here

Wednesday, November 6, 2013

Table types in Team City

create a script that drops the sp's that reference the table type - drop the table type
have this run before the sp's do

HTTP 304 - visibility

You will only see on the browsers network traffic- not Fiddler

Monday, November 4, 2013

How to get to dynamically loaded javascript in browser debugger

in IE if you run it once the script will be available in the source
all browsers - use "debugger"  keyword
all browsers - place breakpoint in static JS and f10 from there

force jquery not to use cache

$.ajax({url: "url", success: Callback, cache: false});


and avoid http 304!