Forum Replies Created
Viewing 15 posts - 5,701 through 5,715 (of 7,499 total)
-
RE: No Operators or Alers
- are you logged in being member of the sysadmins group ? Otherwize you cannot see them.
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 Server Express as a Jet replacement
- Expecialy concurency for processor time, memory
- you should avoid SQLServer being paged out because then the slowdown is drastic !
Express edition is limited to 1Gb RAM, 1CPU and 4Gb...
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 Server Express as a Jet replacement
- Indeed SQLExpress is a valid option.
- you can run it on a non-dedicated server/pc suffering concurrency issues
- pc ? Consider fault tollerence of the hardware (disk & raid1) ?
-...
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: DDL Triggers Distributed Transaction Error
thanks for the feedback.
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: Transaction log growing
A transactionlog records all insert/update/delete activity on a transaction basis to be able to keep the database consistent e.g. in case of servercrach,...
If the recovery model is set 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: 2005 Cluster - Client Components (SSMS) missing from one node
- You need an extra install of the client components on the second node.
You're just installing a client, so there's no need to failover the sqlserver-server instance to the node of...
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 run a query in single user mode ?
-If you want to be sure about the hypothesis that another user is faster than your connect with QA, change the auditlevel to ALL connections (serverproperties\security). This way all login...
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 run a query in single user mode ?
http://support.microsoft.com/kb/307487
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: Creating Multiple indexes in one SQL statement
You'll need 3 statements to perform this action
- one way to speed it up might be to put your indexes on another disk as the rest of your data.
-...
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: on Delete Trigger
- Think of te consequences of auditing this way (data volume)
- Check "create trigger" in BOL
e.g.
create
trigger trg_D_yourtable on yourowner
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: Timed out with Views
30K is not big these days
-If you can, post the view definition.
-Is the join being performed on indexed columns in both tables ?
-...
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: Timed out with Views
- Are there others trying to use the view or the underlying objects ?
- what's your isolation level (should be "read committed")
- Are there any exclusive locks on the underlying...
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: stupid question, but the solution escapes me
Maybe this is simple enough
select
PRODUCTID, SUM(qtysold)
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: Linked server to RDB (oracle 7x)
This linked server definitions is working !
EXEC sp_addlinkedserver 'RDBSvr',
'Oracle RDB Driver',
'MSDASQL',
'OracleRdbTest1' -- system dsn with all the nifty details
GO
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'RDBSvr',@useself=N'False',@locallogin=NULL,@rmtuser=N'myuser',@rmtpassword='mypwd'
GO
SELECT *
FROM OPENQUERY(RDBSvr, '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
-
RE: greatest(a,b,...) function
You could off course create your own user defined function.
There are many examples at SSC.
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 - 5,701 through 5,715 (of 7,499 total)