Viewing 15 posts - 9,721 through 9,735 (of 13,469 total)
it might help...the devil is in the details.
the pseudo code example we have so far doesn't give us enough to work with...if the big table has an index on the...
April 9, 2010 at 10:50 am
I think by just adding to the WHERE statement to Gianluca's fine example, you'd make sure you don't change fields where they already match, you'll prevent re-processing of the same...
April 9, 2010 at 10:40 am
get a copy of the free program SQLRecon from specialopssecurity.com[/url];
it is the most full featured pprogram I've found for discovering all the SQL servers on a network;
the documentation says it...
April 9, 2010 at 8:58 am
Once again, you guys helped me be a better programmer; I learned a lot with this thread.
converting that MTVF to an ITVF made me understand the concept better, and this...
April 9, 2010 at 7:52 am
something like this Simon;
the CHARINDEX function lets you find the position of specific strings within strings; then it is just a bit of tweaking to skip the parts you do...
April 9, 2010 at 4:29 am
the issue is data related; you are going for a diff in seconds; the max value is an integer(2147483648 or unsigned 4294967296?)
but the difference between the two dates is bigger...
April 8, 2010 at 12:27 pm
you have to use a split function which changes the string @tech_list into a table function. otherwise you are trying use IN on a string which just happens to contain...
April 8, 2010 at 11:40 am
the error is related to the row size of the insert; > 8062
for example, if i have 25 columns, and they are all defined as varchar(500), 25 X 500 =...
April 8, 2010 at 10:13 am
a login has only one default database, even when he has access to multiple db's thru different roles;
ig you go to SSMS>>Security>>Logins, you can find either his domain username or...
April 8, 2010 at 8:51 am
i just re-wrote it as well, but the math is quite not right; i'm basically using multiple CTE's to do the intermediate variables as columns, as soon as i have...
April 8, 2010 at 8:10 am
there is an article "zip code Radius search" that can help get you started:
http://www.sqlservercentral.com/scripts/Miscellaneous/30878/
it basically requires a table of postalcode/latitude/longitude, and finds all the records that match within the inputed...
April 8, 2010 at 7:34 am
I'll admit it, I'm weak on inline TVFs; had to look it up;
i've saved a lot of Paul's recent code that was converting other's scalars to inline tvf's but my...
April 8, 2010 at 6:08 am
you might be appending a null to the variable being used for the @body element;
ie SET @body = @firstname + ' ' + @lastname + ' a bunch of info'
if...
April 8, 2010 at 5:07 am
this is a common security issue.
Because "Local System" never logs into a domain, it can never access a share. The logging into the domain is when permissions on shares...
April 8, 2010 at 4:59 am
Seth yes i had actual plan on, but even with it off it's still ~36 seconds;
there's no space expansion or anything going on behind the scenes; i can run...
April 7, 2010 at 7:59 pm
Viewing 15 posts - 9,721 through 9,735 (of 13,469 total)