Tag Info

Hot answers tagged

6

I'm guessing here based on how I'd implement MIRROR TO: Probably, SQL Server streams the backup data to two backup devices if you use MIRROR TO. This means that every block they read is written two times. The data stream has a fork. What they are certainly not doing is write the data once and then copy it over. That would a) incur an additional read pass ...


6

There are two possible ways 1. Automatically create scripts for all SQL Server Jobs I. Open Object Details II. Select All Jobs (Shift + Mouse Click) -> Right Click -> Script Job as


3

Only you can answer if the jobs can be dropped completely. If they are not jobs like from the import/export wizard I would probably script them out. This can be done easily with PowerShell. A quick way of dropping them is via Object Explorer details pane, it allows multiple selections and then just hit the delete key or right click and delete.


3

Based off this and this post I would say, yes, the change from char(10) to varchar(12) will touch every row and hence grow the log. My reasoning being that the column has moved from the fixed-length to the variable-length part of the row structure and the storage engine will have to persist this information straight away. Variable length columns will have ...


3

VSS is being used to backup your database. Edit: [Thanks Colin] This causes the logged 'I/O is frozen' message. It is not serious. No need to resolve it. Be warned, your database restore chain may be impacted, in which case it is serious. If you backup strategy is weekly full, daily diff, hourly tran per day - 8am -5pm; a daily snapshot VSS backup will ...


3

Since your problem is a conflict between constant updates and being able to run reports without facing deadlocks, I would recommend you consider using READ_COMMITTED_SNAPSHOT isolation set ON. This also has overhead, but usually prevents most deadlocking situations. (Nothing is magic, of course.) You should read the details at: ...


2

You could use the Windows System Resource Manager (WSRM) feature for this. It is not present in Windows starting from 2012 R2, but since this is an old SQL 2005, I would expect the OS to be old-ish as well. I've never used it myself, but, though a bit complicated, it might do the trick for you.


2

I use Bill Graziano's Script SQL Server Configuration project on Codeplex for this. It can script the whole configuration of a SQL Server instance to .sql files, including SQL Server Agent jobs. It is a command line utility, so with multiple servers to script, you can use a batch or PowerShell script to loop through all the servers.


2

To get the information for a single instance you would use DaysUntilExpiration value for the LOGINPROPERTY function. This will give you the days until the password expires. You can then cast that as an integer and use the DATEADD function to get the actual date. SELECT name AS LoginName, DATEADD(DAY, CAST(LOGINPROPERTY(name, 'DaysUntilExpiration') AS ...


1

An open-ended range is the safest in terms of granularity and sargability, and being immune to underlying data type changes: DECLARE @today DATETIME; SET @today = DATEADD(DAY,DATEDIFF(DAY,'20000101',GETDATE()),'20000101'); SELECT ... WHERE ordDate >= DATEADD(DAY,-1,@today) AND ordDate < @today; You may get suggestions for other ...


1

The ODBC Connection needs to be a System DSN. The connection is made as the service account, not you, and so the service account doesn't know about your User DSN. From the article: Select the System DSN tab to configure a data source for the entire system.


1

I would write a python script that would, parse the columns descriptor file, get their widths and names iterate over all the data in the input file, splitting out the data into variables construct a sql query with these variables to the sql server with SQLAlchemy to be sent one by one or as a batch of rows or 1000 at a time This script would take the ...


1

Tell me about it? You are speculating. I recommend that instead you investigate. Read How to analyse SQL Server performance. Find the bottlenecks, address them appropriately, based on your findings. Measure before you cut.


1

After doing some online search,I found what you needed,hope my answer helps you. Answer 1 Note: It Only works with transactional and transactional peer to peer replication T-SQL script which you can use to monitor the status of transactional replication and performance of publications and subscriptions. Things to be considered before executing the ...



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