If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a large database (in several GBs or TBs), separating the data into ... you can ...

This means that something as trivial as a sick day can result in a system or data ... file via FTP, the next step is to automatically import that file into SQL Server. To do this, we’ll use ...

The most frequently occurring buffer latching situation is when SQL Server is waiting to read a data file page or workload from storage ... SOS_SCHEDULER_YIELD—SQL Server instances with high CPU usage ...

but we don't always know the name of the instance (Always only 1 SQL Server running on a single server). If this was easy, we'd just run: ...

and the other server is running SQL 2000. What is the T-SQL I need to use in order to delete files older than 'x' days? Since I'm not backing up the SQL 2000 dbs to the same directory, I can't use ...