Re-indexing all the tables on all the databases might be an overkill. You might want to re-index tables which are highly fragmented. I had a script for that somewhere and will try to find it and post it.
2004-08-18
Had this problem and it turned out that the network folder had write permissions but not create. I had the network admin add create/full permissions explicitly to the DBA group and it worked fine.
2004-08-12
Hi All,I have a table (say Table1) with around 182,000 records and it has about 64 rows.Difference between below 2 queries is significant and difficult to understand why.SELECT TOP 134 * FROM Table1 ORDER BY Field1, Field2, Field3 - Above completes in about 3 secondsSELECT TOP 135 * FROM Table1 ORDER BY Field1, Field2, Field3 - Above takes […]
2004-07-10
Given the fact that you need to delete messages from the client machine you are forced to use a DTS package running at intervals. The Replication models are just that - Replication of data from one server to another. Therefore if you delete data at one end the other end will mirror this exactly.Once you […]
2004-06-29
For God's sake, DO NOT use a NAS with SQL Server. You are asking for nothing but trouble. Even Microsoft does not recommend it. I've used Network Appliance NAS and EMC and CLARIION SAN's as well as Raid Arrays, and I'm telling you NAS is bad news. It was never designed to service Databases and […]
2004-06-15
FYI - when I need to counts by date on a DateTime field where the time value is populated, I just zero out the time value withSELECT CAST(Convert(VarChar(8), GetDate(), 112) AS DateTime) ...
2004-06-04
2004-05-25
I have a 1-to-many relationship between my "Game" and "GameInfo" tables. TABLE: GameGameID, GameName TABLE: GameInfoGameInfoID, GameID, DateTimeOfThisPieceOfInfo, GameInfo Let's assume that there are multiple records in GameInfo for GameID 1. I want to write a query that only returns the row of GameInfo where the "DateTimeOfThisPieceOfInfo" is the latest date. For clarity, here's how I would […]
2004-05-10
nchar(unicode)select nchar(0x2265)results: =
2004-04-02
Hi Steve,Thanks for the information. Actually I am looking for information or examples more related to setup processing rules to capture different type of events and generating alerts. Please let me know if you have some related information.--sntiwary
2004-03-09
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