Viewing 15 posts - 6,916 through 6,930 (of 8,416 total)
sarath.tata (9/14/2009)
hey,the problem is I don't have this stored procedure in master. So I'm unable to run it.
You really really really do have it you know 😉
It's part of SQL...
September 14, 2009 at 5:53 am
You're both correct, but I prefer CC's answer.
The full reference starts by saying:
Books Online
September 14, 2009 at 5:31 am
Just to follow the Moden Rules, here's a demo of a truly non-deterministic function:
CREATE FUNCTION dbo.fn_test2()
RETURNS BINARY(8)
WITH SCHEMABINDING
AS
BEGIN
RETURN CONVERT(BINARY(8),@@DBTS);
END;
September 14, 2009 at 5:25 am
Rob Fisk (9/14/2009)
Surely using a constant can't be a negative though. I mean, COUNT(0) has the old school and William Gibson cool factor.
I will give you that. I'm just...
September 14, 2009 at 5:10 am
Dave Ballantyne (9/14/2009)
Think these guys are on the same course ? No conferring now gentlemen 🙂http://www.sqlservercentral.com/Forums/Topic787196-146-1.aspx
http://www.sqlservercentral.com/Forums/Topic787221-338-1.aspx
Fascinating question though.
September 14, 2009 at 5:08 am
Yes, I'm trying to wean myself off sp_change_users_login since it is now deprecated in favour of ALTER USER :w00t:
September 14, 2009 at 5:02 am
To be absolutely 100% clear on this: SQL Server contains code to recognize COUNT(*) and EXISTS (SELECT * constructs early on. No column meta data is ever accessed. ...
September 14, 2009 at 4:59 am
Gianluca Sartori (9/14/2009)
I didn't know that the engine ignores the changes to the db state.
I'm just wondering why you seem to know the topic so deeply: maybe...
September 14, 2009 at 4:49 am
Will the '1 is more efficient than *' myth never die? It was briefly true for DB2 and Oracle (in different ways) but that was all a very, very,...
September 14, 2009 at 4:44 am
I told y'all Matt was one of the good guys :w00t:
September 14, 2009 at 4:31 am
Pedro,
Yes - you state it well. And yes, there may be other good reasons to use extra file groups.
I am a big fan of extra file groups for all...
September 14, 2009 at 4:29 am
Functions are prevented from calling a stored procedure directly as part of a package of protections built in to SQL Server.
These protections guarantee that the state of the database does...
September 14, 2009 at 4:23 am
It's all good, Bob - totally my error :blush:
Now. Can I interest you in any double-glazing? :laugh:
edit: Thanks, Lynn
September 13, 2009 at 9:56 pm
You're right Lynn - and I did mean to post an introduction...but life got in the way I'm afraid. Sorry.
Many of you might recognise Matt's name from the forums...
September 13, 2009 at 9:50 pm
Me too. I was rather hoping to avoid temporarily setting up replication.
Another approach is to detach the database, then attach it using CREATE DATABASE with the REBUILD_LOG option.
I'm a...
September 13, 2009 at 9:37 pm
Viewing 15 posts - 6,916 through 6,930 (of 8,416 total)