RE: Slow Performance issue
is there a primary key on the table? if so is it clustered??? have you looked at the data load options in your dts package ??? are you using the fast load options ??
2004-07-22
Power BI
RE: Need help implementing FILO ordering on fixed size database
For our 24x7 website we have a number of tables that record session information, including each page a user visited. this table averages around 4-5mil records. To keep the size manageable, we run a job every hour which moves records older than 60 days into an archive database. We used to run it every day […]
2004-06-22
RE: i have a date problem
There is only one date format that will cause you no trouble, no grief, no nothing wherever in the world you'll go. This is the standard ISO format ssyymmdd (eg 20040609) In SQL Server its convert style 112. As already noted, mm/dd/yyyy and dd/mm/yyyy is no good, because this is ambigous formats relying on other […]
2004-06-09
RE: What are DR2 files?
You may be getting this error message when the file you transfer contains a DRI in this case a non clustered index. Regards
2004-05-07
Default values
Can anyone explain to me the difference between using DEFAULT CONTRAINT and sp_bindefault to set a default value on a column?Which one of the methods is preferred?ThanksJohn
2004-03-08
RE: OLE DB provider EDAOLEDB.1
Sorry, I gueas I shouldn't hit enter. -- anyway the query is something like select column1,column2 from openquery(EDACONN,'select column1,column2 from table') We can run it, it returns 78000 records. We can run it about 3 - 4 times then we'll get an error ... OLE DB provider 'EDAOLEDB.1' reported an error. The provider ran out […]
2004-02-04
1 reads
RE: Query date and time data
> select * from test where chkdate between '20040106' and dateadd(s, -1, '20040107')This might work with smalldatetime values, but it will possibly exclude some datetime values for that date. See my predicates using >= and < rather than BETWEEN.> select * from test where dbo.Dateonly(chkdate) = '2004-01-06'Three problems with this:By using a conversion style that uses only two digits […]
2004-01-28
1 reads
RE: Can I Recover to a previous point in time?
You can restore to an earlier point in time. Let's say you want to restore to 1 January. Restore a full backup from that day or a previous day (use WITH NORECOVERY). Then restore any transaction log backups that may have data up to 1 January (use WITH NORECOVERY on all but the last one). […]
2004-01-23
1 reads
RE: QOD 9 Dec 03 - Users
Shoot the database designer! These questions just get worse over time. They mention, "Districts" and then have "DepartmentID". Nice. Furthermore, it is clunky and silly to implement database row level security, even in views for just such a thing. We do this continually through the application level, where it makes more sense and is ten […]
2003-12-09
RE: remove publisher table
It could actually be a huge difference in effort if you have dynamic subscriptions set up. BTW: see sp_dropmergearticle in BOL Gary Johnson Microsoft Natural Language Group DBA, Sr. DB Engineer
2003-09-03
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