I've got a Data Warehouse team that's decided to use the database object ids to keep track of their SourceSafe SQL server code.I remember a hideous application way back in the 7.0 early days that did just that, and it caused us all kinds of grief. You can never drop an object. You have to […]
2004-09-23
This script proves things nicely: CREATE TABLE #TestUpdateA (ColA CHAR(1), ColB INT) GO CREATE TABLE #TestUpdateB (ColA CHAR(1), ColB INT) GO INSERT #TestUpdateA (ColA, ColB) VALUES ('A', 0) INSERT #TestUpdateA (ColA, ColB) VALUES ('B', 0) INSERT #TestUpdateA (ColA, ColB) VALUES ('C', 0) GO INSERT #TestUpdateB (ColA, ColB) VALUES ('A', 1) INSERT #TestUpdateB (ColA, ColB) VALUES […]
2004-09-20
Hi There,Could somebody help me with the following messages i have on my server?Error: 17833, Severity: 18, State: 1 2004-09-13 13:54:25.85 ods ListenOn connection '1433' is already in use..thanks!
2004-09-14
10 reads
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-08-30
I open up SQA (2000) connecting with windows authentication looking at a SQL 7 Server.Put in a number of random (fairly simple)selects to get an example for testing.Do a number of selects from a table called plan_ which work fine. Then when doing a JOINed select between the plan_ table and another table I get no […]
2004-08-13
1 reads
I goofed on the 'rs'. should have been [order detail]. I now get a result but the count is the total number of records for each productid and since the inner query is executed once for each outer query record, I have it backwards. I guess what this all boils down to is that I […]
2004-07-28
Hey Doug,Maybe breaking it out will make it easier to see...(select min(foperno) from #temp t where t.fjobno = t1.fjobno and t.foperno > t1.foperno)Steve
2004-06-24
Shrinking a file depends on WHERE the free space is actual located. A log file tends to look like this: (code A = active I = inactive)A I I A A A I I AAin other words, a mixture of active and inactive portions. Shrinking the file only shrinks (removes) the Inactive portions from the END […]
2004-06-24
2 reads
That's not true. All I remembered was that for NW and named instances that the port number was some unbelievably large number and therte was only one answer that had a very large number. Not rocket science.
2004-06-23
Here's something I got from the Microsoft site -- Works pretty well(Sorry all the indenting goes out of it with this post. Get the original off the MS site if you want -- see note): /*========================================================================= Title: Shrink SQL Server Transaction Log Script SQL_Server_Trx_Log_Shrink.sql Purpose: INF: How to Shrink the SQL Server 7.0 Transaction Log […]
2004-06-22
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers