Forum Replies Created
Viewing 15 posts - 6,121 through 6,135 (of 7,502 total)
-
RE: Awe related qry.
just to add to Balmukund Lakhani 's replies :
- check you have installed SQL2000 Enterprise Edition !
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
-
RE: Error: 9002 Log file for database xx is full. But it''''s not!
If you can, don't shrink the logfile !
Every extend it needs, takes an extra efford of your server.
It only extends if needed, due to transaction load.
It's a good choice...
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
-
RE: Error: 9002 Log file for database xx is full. But it''''s not!
alter database xx set RECOVERY SIMPLE .
This way every ended transaction's logspace is immediatly set available again.
Point in time recovery is not possible. you can only restore fullbackups and differentials.
If the sum transactions...
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
-
RE: case function with row count
select mycol, case when myrowcountcol > 1 then 'High'
when myrowcountcol < 1 then 'Low'
else 'ONE'
end as HL
from (select mycol, count(*) as myrowcountcol
from .....
group by mycol
) 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
-
RE: using cdosys mail
We use Gert Drapers (SQLDev.Net) XPSMTP and send the queryresult as an attatchment.
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
-
RE: SA AND BUILTIN\ADMINISTRATOR MODIFIED
you'll need to use sp_changedbowner to change a db's owner.
sa = systemadministrator = omnipotent meaning has all authority to do anything with all db of a serverinstance. If you make...
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
-
RE: Order of columns
IMO the problem is that your primary key is CLUSTERING !
This also has an impact to _all_ NCI !
Drop and recreate your Primary key but make it non-clustering.
Create a clustering...
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
-
RE: Help with script that mails the dba when db backup fails
DECLARE @Date_Time_Requested DATETIME
DECLARE @Count_TimeOut_Records INT
DECLARE @MailMessage VARCHAR(8000)
DECLARE @NewLine CHAR(2)
DECLARE @Oldest_Date DATETIME
DECLARE @EmailAddress VARCHAR(50)
DECLARE @MailSubject VARCHAR(150)
---Initialisation
SELECT @Oldest_Date = getdate()
SELECT @Count_TimeOut_Records = 1
Set @EmailAddress = 'yourmailaddress@yourprovider.whatever'
SELECT @NewLine = char(13) + char(10)
SELECT @MailSubject = 'TEST ! (...
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
-
RE: SQL Agent puzzle
@query = 'select * from AIS.dbo.vwOrdersShippedNotInvoiced'
this may "sound" redicule, but that's how it always works overhere
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
-
RE: Urgent problem peformance issue after database migration
I suppose each node hosts 2 active instances of sqlserver.
On each node the active instanceses will compete for the ram (6Gb < 2*4Gb) and cpu (4speed cpu < 2*4slow ? ) ....
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
-
RE: Urgent problem peformance issue after database migration
btw "...The databases migrated from four standalone servers with quad processors and 4 to 6GB of memory...."
could it be that .... 4 * 4slow + 4*(4 to...
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
-
RE: Urgent problem peformance issue after database migration
may I add ....
DBCC dbreindex all your tables and indexed views and indexes.
dbcc updateusage(yourdb) with count_rows
sp_updatestats all your db
and SP4 has changes regarding implicit datatypeconversion ! This may have 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
-
RE: How to make encrypted data accessible to one specific user?
http://blogs.msdn.com/lcris/archive/2005/06/10/428178.aspx
explains a bunch of it !!
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
-
RE: How do I get SQL Server version (numbers only)
select
replace( cast ( serverproperty('ProductVersion')
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
-
RE: Slow query performance vs 2000
This kind of poor queries will have you suffer long time
here are some more solutions.
I guess the CTE is a good example,...
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
Viewing 15 posts - 6,121 through 6,135 (of 7,502 total)