Tag Info

Hot answers tagged

4

<Getting this out of the way first.>It's generally not recommended to put SQL on a DC. (I know, you probably inherited it that way, moving right along.)</Getting this out of the way first.> You can indeed do this if you're willing to take SQL down. Shut down SQL in Services. Start an administrative command prompt. Navigate to the folder ...


1

I wouldn't actually execute this myself. ;) However. Declare @procid int, @SQL nvarchar(max) SET @procid=60 WHILE @procid < 100 BEGIN set @SQL='kill ' + CONVERT(nvarchar,@procid) EXEC SP_EXECUTESQL @SQL SET @procid=@procid+1 END As for processes from a specific hostname or username: DECLARE @Table TABLE( SPID INT, ...


1

It's not asking you to restore master. It's asking you to not be in DBASE while you're trying to restore DBASE. Try: USE MASTER GO ALTER DATABASE DBASE SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO RESTORE DATABASE DBASE FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.DBASE\MSSQL\Restore\DBASE.BAK' WITH MOVE 'DBASE' TO 'C:\Program ...


1

This function creates a data dump, not imports it, which is the opposite of what you want to do. The TEXT you are referring to is the path to the CSV file it will generate. PgAdmin 1.4 seems to have a restore facility: http://www.pgadmin.org/docs/1.4/restore.html If you are trying to import data into a single table, you can right click on the table in ...


1

This is taken straight from the manual, please consider it as a requirement: You cannot run SQL Server services on a domain controller under a local service account or a network service account.


1

Its very simple.You need to generate a script for that. Right click on your database name from the object explorer and follow these steps - Task> Generate Script> Next> Select Specific database objects> select table and click next> Click "Advance A pop up windows will appear named "Advance Scripting Options". Find "Type of data to script" under "General" ...


1

Also Oracle Server Seam to adapt to expected loads rather than current load. So if you utilize the servers differently you will get different caching behavior. Also check the execution plans carefully. If there is a slightly different execution on the big select like an skip scan instead of aindex scan it might explain everything.



Only top voted, non community-wiki answers of a minimum length are eligible