Viewing 15 posts - 3,181 through 3,195 (of 7,502 total)
And there are off course "cumulative hotfixes" = a set of hotfixes, but not as tested a you would expect for a service pack
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 8:05 am
If this is to figure out if a db is still being used, just alter your db option "AUTO_CLOSE" to ON.
This way, you will find a "database opened" message in...
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:58 am
- Read the according KB ref for the hotfix !!
- Test it on a DBA test server to prepare yourself for the production rollout (timing, expected problems,..)
- Is this a...
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:54 am
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
Viewing 15 posts - 3,181 through 3,195 (of 7,502 total)