My experience is that BLOB will inflate the database excessively if the requirements are heavy. Therefore, I prefer using linking instead of embedding. It is a highly recommended approach for massive image requirements (which is the case where I work). Also, it makes it much easier for the Graphics Designer to design the image using […]
2003-07-08
SQL Server Agent maybe fail to start after fail-over. Check SQL Server Agent log (Display error log) from EM and review machine application/system logs too.
2003-07-07
1 reads
quote: I want to compare the DDL/Schema, Views and Stored procedures on two versions of my database. Is there any utility or scripts to do that ? Thanx in advance. Prateek.
2003-07-07
1 reads
To test this out, I create a job 'AddUser' which just contained the code sp_addlogin 'test'. Not sure whether it is possible to use SQL-DMO in Access 97 so I tried using Transact SQL in Query Analyzer: Use msdb EXEC sp_start_job @job_name = 'AddUser' Still a SYSADMIN problem which I overcame by using xp_sqlagent_proxy_account. Managed […]
2003-07-02
Try moving the variables/parameters to the WHERE clause. Having them as part of the join condition may be causing the stored procedure to recompile each time it is called. update dbo.tMappingRule set ratio = r.ratio from dbo.tMappingRule mr inner join tMappingTemplateRule r on r.AccountID = mr.AccountID and r.LevelID = mr.levelID WHERE mr.DataCycleID = @DataCycleID and […]
2003-06-17
I have not seen any white paper from Microsoft regarding best practices of a reboot schedule. In our organization, we only reboot the servers when patches are applied or (rarely) when hardware fails and necessitates downtime. To enable that long term reliability, only the bare minimum services and software are installed on the dedicated SQL […]
2003-06-13
1 reads
I may be over-simplifying this, but: SELECT col1, Max(col2) FROM t1 GROUP BY col1 --SJTerrill Ah, I'm definitely over-simplifying. I believe you'll have to resort to subquery to return the contents of the whole row. Edited by - TheWildHun on 06/12/2003 12:49:27 PM
2003-06-12
2003-06-06
1 reads
2003-06-04
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
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