2005-04-21
aws
RE: Best Practices for Database Design
Why prefix views with a 'v'? Tables and views are identical as far as clients are concerned -- there is no reason to muddle your data model with that prefix. Also, please define "reference". At what point does a "reference" table cease being for a reference? Can a non-reference table become a reference? Will you […]
2005-04-05
2005-03-31
Displaying relationships on databases/tables
Is there a sql command that would list all the relationships on a database or even just a table?uanita
2005-03-29
1 reads
RE: Sql Server 7 Memory
Where can I find more information about memory configuration in SQL Server 7
2005-03-24
RE: Connection Issues
Just did. I enabled Network Transactions,Network Adminstration, and Network Clients.I can establish a connection to this Server with the XP box no problem. The other W2k3 box only connects to it when I specify the IP address (when using TCP/IP) otherwise I have to enable NamedPipes. I'm lost.Thanks again!
2005-03-03
RE: Executing SQL in ActiveX Script Task
You can do the file system stuff with FileSystemObjects rather than your text file:Dim objFsoSet objFso = CreateObject("Scripting.FileSystemObject")Then see http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/fsoorifilesystemobject.asp for all the nice things you can do.The way I used to run a query on an existing connection in an ActiveX task might not be the best, but it does work. I set up an […]
2005-02-04
1 reads
RE: Export to csv file crashes EM
Hi,I've just been having the same type of problem. I got around the problem by using the DTS Export Wizard, specifying the Destination = Text File (and the file name as the .csv file you want to create), and then you get to specify the csv file format you want, with the right delimiters etc). If you […]
2004-07-23
RE: DORMANT Status
Same as Sleeping, except Dormant also indicates that the SPID has been reset after completing an RPC event. The reset cleans up resources used during the RPC event. This is a normal state and the SPID is available and waiting to execute further commands. bye
2004-05-14
Date range in query removes outer joins?
Hi all,I have this stored proc where I need to display all the subGroups and Indicators, whether or not they have any tasks assigned to them. Basically, I have 3 tables: SubGroup (from where I need all subgroups), Indicator (I need all indicators, too), and Task. If I run the query WITHOUT the date range part, it returns […]
2004-03-22
2 reads
Blogs
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...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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