Hot answers tagged sql-server-2008
I wouldn't delete it, just in case you run into problems. If space isn't an issue create a copy of the original files with the instance offline, rename the original (so they aren't found on restart) then try: CREATE DATABASE MyDatabase ON (FILENAME = [mdf path]) FOR ATTACH_REBUILD_LOG
SQL Server uses a cost based formula for determining how to satisfy queries. "It'll cost 10 random reads in a billion row table vs 1000 sequential reads. I think I can satisfy the needs faster by doing the 1000 reads since they'll all in order" and decision made off it goes. Unfortunately, when the engine opens the data file to find those 1000 sequential ...
Here is a run down of some of the options I have used to audit logins and logouts. I haven't had the chance to use Extended Events for auditing purposes yet. Below I quickly describe tracking login and logout events using SQL Server tracing and SQL Server Audits. You'll probably end up going with setting up background server tracing which is described ...
The first thing that comes to mind is a logon trigger. But that's not really the right answer. The right answer is to give the logins (your Windows users) only the permissions they require. An application is not a security layer and you shouldn't be treating it as such. In other words, if the users are able to SELECT and INSERT into dbo.Table1, then they ...
You may be experiencing an issue with ascending keys, which is leading to a poor execution plan choice. SQL Server builds statistics with the assumption that the data will by in large be similar in the future. However, when data typically ascends, most new insertions are out of the previously found range. This can lead to poorly performing plans ...
May sound drastic but if you can't find a good way to debug within SSIS then you can always resort to Network Monitor or Wireshark. That way you can see what's happening during the FTP session. Another option may be to ask for some extra FTP logging on the receiving end.
Only top voted, non community-wiki answers of a minimum length are eligible