quote: Thanks Jonathan, I read the paper (Automating Statistics Management for Query Optimizers ). Very **very** complex! If I understand well, there's no simple rule of thumb. You have to try and to test (heuristic approach) and so on ... Am I right? Patrick SIMONS, MCP Yes, that paper is quite technical... You can guess […]
2003-12-15
Also worth checking any other usage of SQL instance and/or server in general. What about fragmentation of indexes? Has the query plan changed? Are your statistics now out of date?
2003-12-15
This may not be the best way, but I guess you could check the existance of rows in the inserted and deleted tables, eg: If there is an entry in the inserted table, but not the deleted table, you know it's an insert. If there is an entry in both, it's an update. If there […]
2003-12-15
I would verify whether the performance decrease was caused by the backup. You may consider to perform full database on weekly basis and do the differential backups for the rest days. Perform differential backup should be fast in general than the full backup. But you can't use maintenance wizard to do it, you have to […]
2003-12-12
1 reads
Hi all Your not going to believe this, good ople SQL Server Yukon Beta 1 is only avail for MSDN Universal subscribers in the US (on request), us Aussies were given the royal boot 🙂 Convicts cant be trusted apparently 😉 Cheers Ck Chris Kempster www.chriskempster.com Author of "SQL Server 2k for the Oracle DBA"
2003-12-11
2 reads
EXEC sp_columns @table_name = 'TableName' ,@column_name ='ColumnName'
2003-12-10
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!
2003-12-09
Hey, did you get promote by this post? That's a rather pessimistical picture, I think. I have heard of computer freaks who are still able to communicate with each other by a tool called 'word of mouth', 'face to face' or something like that. At least that's what a friend of mine mailed to me. […]
2003-12-08
1 reads
Read the article and judge then. Image data is for binary data in general! Frank http://www.insidesql.de http://www.familienzirkus.de
2003-12-04
1 reads
I had the same problem so I use the following: WHERE Convert(varchar(10),date_key,101) Between @Startdate and @EndDate @Startdate being '10/16/2002' @EndDate being '10/25/2002' Edited by - cfeisel on 12/02/2003 10:29:34 AM
2003-12-02
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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