hmmm, why do you subtract 36161 from date? anyway, it is better to not use such a terrible constructions that prevent index seeks, you should always...
You can also use OPENROWSET function as such: update openrowset('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=d: est_update.xls', DataSheet$) set...
Try to rewrite this view's query as shown below: select srid, status, explanation from dbo.dds_intStatusLog sl where sl.id = (select max(actsl.id)...
Show us tables' structures, indexes and execution plan. WBR, Vlad A. Scherbinin
And what indexes do you have? WBR, Vlad A. Scherbinin
it depends <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />WBR, Vlad A. Scherbinin
Books Online: create trigger + UPDATE(column) or COLUMNS_UPDATED() WBR, Vlad A. Scherbinin
Hello, All! MS SQL 2k EE SP3a, merge replication. After long time Conflict Viewer began to hang when viewing conflicts on some articles (not on all)....
May be select * from sysobjects order by checksum(newid()) ? WBR, Vlad A. Scherbinin
BOL: DBCC DBREINDEX DBCC DBREINDEX is automatically atomic WBR, Vlad A. Scherbinin
Take a look at BOL: Roles WBR, Vlad A. Scherbinin
db_owner already has all permissions in the DB. WBR, Vlad A. Scherbinin
In this case you must use sp_executesql instead, like this: declare @cnt int exec sp_executesql N'select @cnt=count(*) from sysobjects',N'@cnt int...
You don't loose that 15 min data, if your tran. log doesn't corrupted. In that case you can use BACKUP LOG WITH NO_TRUNCATE and then this backup will...
If you add a new table to the publication, you will need rerun snapshot agent. WBR, Vlad A. Scherbinin
sp_msforeachdb 'use ?;exec sp_spaceused' WBR, Vlad A. Scherbinin
It is good idea to take full backup of the master DB, after making some of the following changes: 1. Creating/altering/dropping DBs. 2. Changing...
1. Just like you create other indexes. 2. Yes, it is just a normal index. 3. Yes. WBR, Vlad A. Scherbinin
Write caching without UPS or on controllers without independent power supply. (may result in so called "torn pages" and suspect DBs). P.S. MS SQL...
Is this function deterministic? If so, you can create calculated column and index on it. This can improve performance significantly. WBR, Vlad A....
Separate names with a comma.
