RE: Optimizing Your Application - Part 2
The Dataset class is designed to cache data. Why create another structure to hold multiple datasets each with one table, when you can create one dataset with multiple tables?
2005-02-25
Log Shipping
RE: ''''Chopping'''' up a ntext field
Hi,I did make that amendment, I was just saying that I need to clean up the data somewhat. Thanks for your help.Much appreciated,James Knight
2005-02-14
RE: datetime
1) WHERE (DATEDIFF(d, datelogged, GETDATE()) = 1)2) WHERE (despatchdate BETWEEN '" & convDate(dteFromDate) & "' AND '" & convDate(dteToDate) & "') 'Using function to massage date.3) WHERE orderdate > Getdate() - 3
2005-01-04
Less records according to Enterprise Manager
Hi All,In using DTS to transfer records from one table to another I found that I ended up with more records in the destination table than existed in the source table....according to Enterprise manager that is!When I use query analyser to do a select * from SourceTable, I get the expected number of records.It seems […]
2004-12-29
RE: Backup file paths
Try thisuse msdbgoSELECT backupset.database_name, backupmediafamily.physical_device_name FROM backupmediafamily INNER JOIN backupset ON backupmediafamily.media_set_id = backupset.media_set_id WHERE (backupset.backup_finish_date > '10/06/2004')
2004-10-07
RE: Count day pr mont, year
Hi Aaron!I still have som small problems with the query. The total sum are correct! Thanks!It dosen't make the sum pr department(ANavn) It take alle togetheter pr month. Also if it isen`t any cars that have been created(gjelderFra) or deleted(SiOppforsikringFra) one mont it dosen`t make the sum for that month it jumps over it.Thanks for […]
2004-10-06
RE: Login Permission
Since it's a service account, you don't want to alter the logon hours. You may, however, want to secure what systems it can logon to. However, since the concern is that someone will use the service account to connect to SQL Server, it would already have the ability to log on to the server needing […]
2004-10-05
RE: Query Analyzer slow and spor attic
Dan did you try accessing the db locally on the server with the same problems? o/w when you connect in EM, you can choose between win auth and sql server auth - I'd suggest trying both and if only win auth causes problems then the lag might be going from the server to the dc […]
2004-10-04
Query analyzer not starting
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-09-27
RE: NT authenticated db owner
Stander,If you want to map an id to dbo, execute sp_changedbowner 'domain\user'. You can also mention a sql id here instead. Bill,You can use the runas command with netonly. The -netonly option will take you out of the current domain and will allow you to use windows authentication to work across domains which are not trusted. […]
2004-09-10
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