Viewing 15 posts - 3,376 through 3,390 (of 7,429 total)
Sounds great. Let us know your results. It would be nice to definitively say under X condition using a UDF has the following bennifit, under Y condition SPs are better...
February 10, 2003 at 12:58 pm
Well nice to know they thought of that at least. Bet they are using data pointers thou so the referenced value is a memory location tied to the data pulled...
February 10, 2003 at 4:58 am
The only way I know you could accomplish that is setup a deliminator and pass all row details for every field item, so that you can identify the points to...
February 10, 2003 at 4:42 am
The Constant Scan logical and physical operator introduces a constant row into a query. Meaning the value does not change.
However if you change the input value it should change as...
February 10, 2003 at 4:33 am
Well,
I think your thinking of SQL Developer Edition or SQL Enterprise Edition with regards to Indexed views. Yes, I have a copy of each we either got thru purchasing directly...
February 10, 2003 at 3:52 am
It is in Logins under Security. The problem is the sid is different and can no longer be validated. Drop the account from login will make it disappear from SQLs...
February 10, 2003 at 3:24 am
Confused here. Unless you need to run 2 instances you just need one copy licensed for 2 processors (Which is technically 2 copy costs). See http://www.microsoft.com/sql/howtobuy/production.asp
February 10, 2003 at 3:21 am
There have been threads on this but I cannot find them. Anyway to the best of my knowledge there is no way. The information comes from sysdatabases in master from...
February 10, 2003 at 3:18 am
New discovery for me. Functions don't seem to take advantage of indexes and may executre only once (run as determinsitic) depending on various factors which means the results only output...
February 7, 2003 at 3:29 pm
quote:
From the apparent scans, a UDF does not use the index. Does this seem correct or am I missing something?
February 7, 2003 at 3:00 pm
Ok since this is the title of the thread "Worst Security hole I have ever seen" I thought I would include on thing that gets more people into trouble...
February 7, 2003 at 2:54 pm
The key are these
to disable
ALTER TABLE tablename NOCHECK CONSTRAINT all
ALTER TABLE tablename DISABLE TRIGGER all
to enable
ALTER TABLE tablename CHECK CONSTRAINT all
ALTER TABLE tablename ENABLE TRIGGER all
Just replace tablename...
February 7, 2003 at 2:46 pm
Ok some may laugh (no I don't do drugs at all but I do suffer from the fact my brain is constantly going and taking things apart) and some may...
February 7, 2003 at 2:40 pm
I think I understand now. And it makes perfect sense. See the key is I only tested a single run and when I increased the conditions to scan thru the...
February 7, 2003 at 2:23 pm
Viewing 15 posts - 3,376 through 3,390 (of 7,429 total)