No Backups or Maintenance was running. I was looking at active processes and nothing strange things were happenging at that time. The query (store proc) is called by aspx page and it's been running our site for at least 1/2 year without too much trouble except the fact is that the proc is heavy. And interesting […]
2004-06-09
Hi I am trying to disable a transactional replication on a server but its giving this error message.Login 'Distributor_admin' is aliased or mapped to a user in one or more databases. drop the user or alias before dropping the login.Thank you for your help
2004-05-21
13 reads
Should I create a job that runs a large DTS package with many tasks or create a job with many steps in which each step runs a small DTS package with a few tasks. What are the pros\cons of each approach?TIADean
2004-04-14
1 reads
Hi stacenic, Liked your post and would be grateful if you could post this script or email it to me on andrewkane17@hotmail.com. Regards Akane
2004-03-31
I have a Development and production server that are Identical. I am calling a stored procedure on the Production server and it is taking approximately 30 seconds to run, where as on the Dev. Server the same exact SP takes 1 sec to run.I have both execution plans open side by side and there is […]
2004-03-22
4 reads
If you want speed, you should use nolock. If you absolutely must have the most up to date data, don't use nolock. The difference being that a Select without nolock will wait for any uncommmited transactions to clear before selecting the data. With nolock it will give you whatever is commited to the database.cl
2004-03-19
2004-03-08
If your users are connecting through an application server you can put the SQL Server behind a firewall and just allow access through the firewall to the app server IP address, thus denying enyone else access.
2004-03-04
net stop mssqlservernet start mssqlserverand schedule it at windows level (at command).
2004-03-04
No, not me! But I know a friend who knows someone who has heard, that there might be some people... Actually I only thought about why always reinvent the wheel when someone else has done similar before.
2004-03-03
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