Why is SQL Server So Slow?

I’ve been asked this question a few times when looking into performance problems on a website, and the short answer is, it’s not. SQL Server is a very efficient database. It’s important to remember that a database is just a runtime for your SQL code. It’s just doing what you ask it to do, nothing…

SQL Optimization Tips

• Use views and stored procedures instead of heavy-duty queries. This can reduce network traffic, because your client will send to server only stored procedure or view name (perhaps with some parameters) instead of large heavy-duty queries text. This can be used to facilitate permission management also, because you can restrict user access to table…

Talking about Some SQL Queries

How to Run commands for all tables in current dB: EXEC sp_MSforeachtable @command1 = ‘DELETE FROM ? WHERE your_condition’ The ‘?’ will be replaced by the table name ——————————————————————————– How to find Size of all user tables with the number of rows: EXEC sp_MSforeachtable @command1=’sp_spaceuse d “?”‘ ——————————————————————————– How to find Number of rows in…