I am trying to create a new database on SQL 2005. I have tried to do this through enterprise mgr and QA and it never completes. I have to kill the process. When I go and look at the process I notice that the wait type is the following when it is trying to create the new database:
Even though this might not be your issue, perhaps it can shed some light for creation of databases and disk hardware bottlenecks.
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful.
Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
SQL Server Integration Services can read XML files, that’s known by every BI developer. (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.)
But how far can you go? When does the XML Source component become …
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.