RE: Question of the Day for 18 Aug 2004
I think it's not a tricky question... it's simply a bad question, again.
2004-08-18
Error Log
Determining SQL statements involved in deadlock
I was wondering if anyone can provide some insights on this. As I am dealing with a vendor-supplied system, I have only limited access to the VB code that is generating SQL calls. I have been successful in tracing and correcting a number of deadlocking issues with this system mostly by using info about the […]
2004-03-30
3 reads
Log Error: The log for database is not available.
Hi every body, This error occurs when I´m try to delete some records from one table. Does any one have some idea about this error?! What could I do in this case ?! Thanx in advanced !
2004-03-15
77 reads
analysis services sp3a installation failure
hi,I have ms sql server 2000 (enterprise edition). I tried to install two components of service pack 3a, the database component and the anlysis services component. The two corresponding file I need to download and install are Sql2ksp3.exe and Sql2kasp3.exe, respectively. I had no problem installing the database component, but when I try to install […]
2004-02-24
1 reads
RE: Question of the Day for 29 Jan 2004
B) I always thought an MSDN subscription was the most cost-effective way of licensing SQL Server (and other dev tools) for a development environment...? I agree. I think it is interesting that the most common answer by far is that the developer edition is free. That's what I said. It may not be free exactly, but […]
2004-01-29
RE: DTS Query
Here is the query...SELECT a.no as no, a.date as date, a.key as key, a.memo as memo, b.name as name FROM Cases_Table a INNER JOIN Dates_Table b on a.key = b.key WHERE b.Name LIKE '%TICKLER%' AND len(a.memo) > 0 ORDER BY name, date, no
2004-01-26
RE: Query Analyzer list of SQL Servers is wrong...
Okay, half of the problem is solved. Why isn't Instance B showing up in Query Analyzer?Because my crappy old firewall software decided today that it was evil and needs to be kept hidden. When I turn that off, it shows in the listHowever, the other question remains. Why does it show these other two instances […]
2004-01-23
1 reads
changing columns in transactional replication???
I'm new to replication. It appears that when I create a publication and subscriber this works fine, but it will not allow me to change a published article, i.e. change a column name or length, etc. I see you can add or delete a column from a published article under the publication properties, but how […]
2004-01-23
RE: Log Space Estimate
Rather than estimating, I would do it by taking regular transaction log backups whilst applying the transactions in test mode. Look at the size of the tlog backups (or run queries against the msdb backup tables) and also regularly save results of DBCC SQLPERF(LOGSPACE). That should give you an idea of requirements. BTW: I would […]
2003-12-15
1 reads
RE: Sequential Numbering
Another way to do this is using Indentity, not using it as a property of a column, but as function in a TSQL statement. Using your example: select Identity(int,1,1) as rank, Hiredate, LastName, Firstname into #hireDate from northwind.dbo.employees where Title = 'Sales Representative' order by HireDate Select cast(rank as char(4)) as Rank, cast(hiredate as varchar(23)) […]
2003-12-08
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
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