2003-08-05
1 reads
Resource Governor
RE: How can I show results while WHILE is running
I would recommend using a user-defined trace, use Profiler Event "UserConfigurable:0" to watch it: DECLARE @DebugStr NVARCHAR(100) SET @DebugStr = @eventdate + ' ' + convert(varchar(6), @amount) -- Log Custom message to Profiler User Defined Event 0) EXEC sp_trace_generateevent 82, @DebugStr -Dan
2003-08-04
2 reads
RE: Reindexing the system tables
For shure! I'm running several SAP systems for over 2 years now! My database size is over 150 GB and I have 1300 user connected to. The average transaction response time is still below 0.5 sec. It's running fine, I do not have problems with excepting the system table maintenances.
2003-08-01
1 reads
RE: Reindexing the system tables
Hi nyulg, quote: We are running SAP on SQL2K Ent. Ed. and as you may know SAP is coming with over 27.000 tables. so it is true, that you can run an SAP/R3 system on SQL Server ? Woh, that's pretty challenging, I think. I thought they only use something like Adabas ?!?, SAPDB and […]
2003-07-31
2 reads
RE: Sysfiles table Update
To be sure you have the last status, you can capture the output of the sp_helpdb to check the size of your dbs. You can also use xp_fixeddrives to check free space in all your disks.
2003-07-28
RE: backup filename
Did you try using an output parameter in your stored procedure? From BOL: CREATE PROCEDURE get_sales_for_title @title varchar(80), -- This is the input parameter. @ytd_sales int OUTPUT -- This is the output parameter. AS -- Get the sales for the specified title and -- assign it to the output parameter. SELECT @ytd_sales = ytd_sales FROM […]
2003-07-28
1 reads
RE: UDF on a Linked Server
Have you tried to use openquery to call function in linked SQL Server. For example, select * from OPENQUERY(TSTSQL01,'select * from master.dbo.usysprocess(51)')
2003-07-24
2 reads
RE: poor Question of the day 7_13_2003
Hi Chris, quote: I've been thinking about volunteering to write questions, in fact, so that people could complain about *my* writing for a change. :o) But unfortunately, I'm pretty busy through the end of the year, or the fall at least, so we'll see. as to speak with our sales team: We must communicate this! […]
2003-07-16
1 reads
RE: Trigger on Sysxlogins/syslogins table
Also, if I remember Karen Delaney's talk at PASS correctly, triggers are not guarenteed to fire on system tables. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-20
RE: Problem showing all records
quote: FROM Precertification INNER JOIN PrecertificationDiagnosis ON Precertification.idsPrecertification = PrecertificationDiagnosis.idsPrecertification INNER JOIN PrecertificationService ON Precertification.idsPrecertification = PrecertificationService.idsPrecertification INNER JOIN CommentsPrecertification ON Precertification.idsPrecertification = CommentsPrecertification.PrecertificationIdx Change to: FROM Precertification p LEFT JOIN PrecertificationDiagnosis pd ON p.idsPrecertification = pd.idsPrecertification LEFT JOIN PrecertificationService ps ON p.idsPrecertification = ps.idsPrecertification LEFT JOIN CommentsPrecertification cp ON p.idsPrecertification = cp.PrecertificationIdx I assume […]
2003-06-16
Blogs
The Future of the Social Web Is in Good Hands
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
Monday Monitor Tip: Compliance Checking for Old Versions
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
Making Legend Order Match Segment Order in a Power BI Stacked Column Chart
A reader of one of my previous posts pointed out that the legend order...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers