Viewing 15 posts - 46,231 through 46,245 (of 49,571 total)
Ah. Now I see what you're getting at.
I'd probably call that a macro-type replacement than an inline function, but that's just nomenclature. Probably more of a parser enhancement than an...
June 13, 2008 at 7:28 am
I'm sorry I misunderstood you. If you're willing to explain more what you mean (or link to DB2 documetation) I'll try and help.
June 13, 2008 at 5:57 am
You mean like this?
create function dbo.cube(@x float)
returns FLOAT AS
BEGIN
return( @x * @x * @x )
END
GO
SELECT dbo.cube(4)
😉
June 13, 2008 at 5:34 am
I can't imagne a TechEd with 10000+ people. The local one is max 1200. PASS 2 years ago seemed huge to me, with a bit under 3000 people
June 13, 2008 at 5:29 am
They've been there since SQL 2000, along with the table-valued functions.
eg:
CREATE FUNCTION DoSomeThing (@ID int) RETURNS INT
AS
BEGIN
DECLARE @Result INT
SELECT @Result = SomeValue FROM SomeTable Where SomeKey = @ID
...
June 13, 2008 at 5:26 am
No, because DocumentID is your clustered index and you're not filltering on it anywhere.
Maybe stick with just DocumentTypeId , IsActive, IsTemplate if the ordering column is going to change. It...
June 13, 2008 at 5:16 am
Is there anyone who knows SQL there?
What @@Servername returns is the full name of the SQL instance. In your case, you have a named instance.
"OEMSBSCN-3935" is the server name
"SBSMONITORING" is...
June 13, 2008 at 5:12 am
ID & 3 is doing bitwise manpulation
3 has the bit pattern (just using 1 byte) 00000011
2 has the bit pattern 00000010.
When you do a logical and of 3 and...
June 13, 2008 at 5:09 am
What % of the table is likely to have IsActive 1 and IsTemplate 0?
As a first suggestion, consider this:
CREATE INDEX idx_Documents_Search1 ON Documents
(DocumentTypeId , IsActive, IsTemplate, Title)
Title is in the...
June 13, 2008 at 4:58 am
In general neither. It's not a really good idea to go around killing connections unless you know what the consequences will be.
Better idea is to fix code so that long...
June 13, 2008 at 3:45 am
If you don't have any backup (why not?) then you are very likely out of luck.
You can try the following.
Create a new database with the same number of that the...
June 13, 2008 at 3:43 am
Hmmm. It's not an easy indexing scenario.
Are there any columns or set of columns that are always or most of the time specified in the queries?
June 13, 2008 at 3:36 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic516329-148-1.aspx
June 13, 2008 at 12:42 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic516329-148-1.aspx
June 13, 2008 at 12:42 am
Can you post the execution plan in its xml format please? (saved as a .sqlplan file zipped and attached to a post)
What indexes do you currently have on the table?
June 13, 2008 at 12:41 am
Viewing 15 posts - 46,231 through 46,245 (of 49,571 total)