Viewing 15 posts - 346 through 360 (of 961 total)
Have u considered using service borker or an application layer to do the mail sending.
If your looking for a scheduled process u can do all that you want using SSIS...
June 1, 2012 at 1:51 pm
You cud monitor the counters for buffer cache hit ratio and page life expectancy , also you should keep and eye on your recompiles and complies per sec .
sys.dm_os_memory_brokers
sys.dm_os_memory_brokers
250GB...
June 1, 2012 at 1:42 pm
whats ur most common wait type, it shud give u an idea of where you can focuss your energy. High CPU like mentioned above can be caused by a number...
May 31, 2012 at 2:22 pm
this would be a good place to start your investigation
May 28, 2012 at 9:03 am
if yyou only interested in generating the connection string the same way you can simply create a file with .udl extension enter the details and then rename it to txt...
May 28, 2012 at 8:58 am
What operation do u plan to perform using sysadmin rights?
Do you have a NT Login or SQL account.
What is the reason the client said sysadmin is not allowed.
Admins are...
May 28, 2012 at 8:42 am
do u have backups ? what kind ? do u need point in time recovery ? What is the recovery modle of the database ?
May 28, 2012 at 8:36 am
How are u uninstalling sql server ?
Are u doing it from control panel or by exec of the msi?
May 25, 2012 at 2:58 am
the temp table check is not needed since the table is scoped to the session.
in the where condition I would try the following
where 1 = Case when condition1...
May 25, 2012 at 1:40 am
While i am enjoying this dicussion I wanted to point out there is a more obvious benefit to partioning than just the elimantion of unwanted partitions. Lock escalation occurs to...
May 25, 2012 at 1:36 am
you probably have a startup proc enabled, checkout the below link for details
http://weblogs.sqlteam.com/mladenp/archive/2007/08/14/60280.aspx
May 25, 2012 at 1:11 am
Considering that the SSN cud be used for validation or authentication it might be better to encrypt the column.
Mask it is a permenant change and you will not be able...
May 25, 2012 at 1:05 am
It would be eaiser to simply create an identity columns with a Seed value of 1000. The rownum would need to be calculated everytime the proc is run which may...
May 24, 2012 at 2:28 pm
Viewing 15 posts - 346 through 360 (of 961 total)