DBA From The Cold (9/16/2014)

---

What I would do is grant the user SELECT on the sys.server_principals table in the master database. This will allow the user to see all the...

I am hardly an expert on SSIS but for the first part of your question: will traffic go from a to c to b. yes it will. The work that...

it's as easy as

USE master;

GO

ALTER DATABASE tempdb

MODIFY FILE (NAME = tempdev, FILENAME = 'C:\MSSQL\Data\tempdb.mdf');

GO

ALTER DATABASE tempdb

MODIFY FILE (NAME =...

from the what's new in SQL Server, it is possible you just need to make sure that the same path is on all nodes of the cluster.

Local Disk is now...

did you install sql server with this account or did you change it after the fact? if it was after, did you use SQL Server Configuration manager or the services...

Check if the SQL Browser service is running on the server.

unless there is another reason for loading the results into a sql database, to accomplish what you want you could just use powershell.

$path = "c:\temp\directory"

$nodays = "-1"

$excludes = "*.csv, *.doc"

get-childitem...

Including the error you are receiving might help.

that being said, can you telnet to the sql server from your workstation?

telnet test-sql port Replace port with what ever port your MSSQL...

I dont believe SQL server automatically checks the validity of backups. There would have to be additional steps performed.

You can partially validate the backup without restoring by using restore...

It probably doesnt matter in this case...

sys.dm_os_schedulers should show you how many CPUs are being used.

You are joining on "No" between your two CTEs and since all rows have the same No value all items in SumSalesQtyCommit are joined to SumQtyOnHand. add a join condition...

dan-572483 (8/18/2014)

---

SpeedSkater is describing what I consider to be a bug in MSSQL. If you have installed SQL Express, you cannot install SSIS on the same machine, even to design...

You will have downtime when applying a service pack.

TheSQLGuru (8/7/2014)

---

I was definitely NOT espousing the use of OPTIMIZE FOR as a SOLUTION for this issue - just to expose it. I DESPISE that "feature", because it GUARANTEES...