RE: Intermittent Error on SQL Server Agent:[SQLSTATE 42000] (Error 8198))
try this KB article http://support.microsoft.com/?kbid=834124
2004-02-17
Analysis Services (SSAS)
RE: Stopping a DTS Package..
Hey bellis, soory, misread your question... I would normally set my global var at a TSQL task earlier in the workflow. So workflow might go like [do something generic] -> use TSQL to set global -> DummyActiveXScriptTask (this is where I would set tthe workflow Activex script to check global's value) -> next step that […]
2004-02-16
RE: Help with Export to Temp Table please
This is what i would use in such a case. select col1,col2 into #abc from tbl group by col1, col2 having count(*) > 1delete tbl from #abc where tbl.col1 = #abc.col1 and tbl.col2 = #abc.col2insert tbl select * from #abc -- Amit
2004-02-16
RE: crc error in transaction log
OK this has resulting in another question. I successfully backed up my transaction log but the file size still shows as 350mb. Space used is only 20mb.I went into the shirnk files individually and told it to shrink it to 40mb. It reported that it shrank it but the file still shows as 350mb in […]
2004-02-14
RE: Rebuilding master db on SQL 2000
Thanks for the reply. I guess what I was looking for was what dlls would get impacted without a reboot. And since it is production, to be on the safe side the safest thing is to reboot.
2004-02-12
2004-02-11
Microsoft SQL Server 2000 Analysis Services Performance Guide
Analysis Services is slowly gaining in popularity and many of you might get drawn into setting up a server or developing a system based on this technology. Microsoft has released a performance guide to help you take performance into consideration from the beginning.
2004-02-11
1,221 reads
RE: Connections: How many is too many?
We are running SQL Server 2000.I do not see "The working thread limit of 255 has been reached" in SQL Server error log.So, what you are saying is my performance problems are probably related to something else than the 350 connections and that changing the "max worker thread" would be a bad idea?Is 350 or […]
2004-02-10
RE: Stored Procedure Use Results from another?
I have explored the use of #Temp, doing an insert on that table takes about 4 secs. for about 11000 rows. However, when I attempt to query up any data that is in #temp from another SP I get no results.The nested SPs may be an option, but I can not find any examples of […]
2004-02-07
RE: Queries for complete DB schema?
Frank,Thanks for the info. It's a good starting point although I'm trying to build something that is a lot more comprehensive. ThanksBen
2004-02-05
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
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