Viewing 15 posts - 3,181 through 3,195 (of 7,499 total)
Your Set SQL1 is using @fiscal_month_nm in the sting itself !
That's causing the "must declare varriable" error
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 9, 2010 at 7:49 am
I'll have to check that again, but I tought that with sql2008 that limit was removed for a single OS install. (so one OS hosting n sql 2008 instances on...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 8, 2010 at 6:10 am
your trigger will suffer the use of the inline functions in the not in lists. ( Just a gut feeling, but i assume there are queries in the functions)
If you...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 7, 2010 at 2:47 pm
Don't use "create table" in your trigger,because it will put a lock on the db system catalog !
If you need a worker object, prefer a #temp table or a @table...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 7, 2010 at 1:22 pm
Thank you very much for this valuable feedback.
So this is a windows 2008 clustering issue ... who would have come up with that ??
I think I've been lucky because my...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 7, 2010 at 12:58 pm
Indeed the first bit will take a byte, but a byte can host 7 bits (the 8-th one is used for marking another bit-hosting byte is in the row).
That's...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 5, 2010 at 11:50 am
Tara-1044200 (2/4/2010)
Actually.. I am sorry, i do have indexes.I am changing INT data type to BIT, does it not save any sapce to me ?
it can save you 3 bytes...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 5, 2010 at 4:50 am
Here's a little test I performed:
I am logged in as dba_sysadmin, but in the script I use execute as login to change user context.
Test it;
Create login RegularSQLUser with password='sUPERSecr@'
go
USE [msdb]
GO
CREATE...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 4, 2010 at 1:37 am
Did your mailadmins enable SMTP for your sqlserver ?
AFAIK a "regular" user just needs to be granted use of a sqlserver mail profile to be able to send mails.
So you...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 4, 2010 at 1:00 am
Tara-1044200 (2/2/2010)
Can some one...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 3, 2010 at 7:57 am
Tara-1044200 (2/3/2010)
Only 1 solution i see getting my space back...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 3, 2010 at 7:18 am
Your problem is that your provided string value contains a comma in stead of a decimal !
This causes your convert statement to fail !
DECLARE @str NVARCHAR(MAX)
DECLARE @amount DECIMAL(18, 2)
SELECT ...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 3, 2010 at 5:10 am
also keep in mind a "drop column xyz" is only a catalog operation !
That columns space will only get reclaimed after maintenance or reindex.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 3, 2010 at 5:00 am
and you'll need to convert your date to month-name-part ...
Apparently it returns the data in the same order as the in-list
Select *
from (
Select P.name, TH.Quantity, convert(char(3), TransactionDate, 100) as TrxMonth...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 3, 2010 at 4:40 am
... I see that it still has been rejected as spam by server ...
That is a mail server issue .... contact your mail admins.
They may help you figure...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 3, 2010 at 4:24 am
Viewing 15 posts - 3,181 through 3,195 (of 7,499 total)