Johan Bijnens

Forum Replies Created

Viewing 15 posts - 6,121 through 6,135 (of 7,499 total)

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

September 5, 2006 at 1:13 am

#658478
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

September 4, 2006 at 12:38 am

#658259
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

September 4, 2006 at 12:35 am

#658257
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

September 1, 2006 at 5:33 am

#657985
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

September 1, 2006 at 5:21 am

#657983
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

September 1, 2006 at 5:14 am

#657981
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

August 31, 2006 at 7:51 am

#657799
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

August 31, 2006 at 7:03 am

#657790
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

August 31, 2006 at 6:56 am

#657785
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

August 31, 2006 at 6:48 am

#657780
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

August 31, 2006 at 4:34 am

#657761