ben.brugman (10/21/2016)

---

...

Questions to others in the group:

With examples as these how do we prevent a division by zero. (Because the complete column does only contain zero's). (The same for averaging...

If I understand your question correct, this could give you the results you need:

select PtLanguage

, sum(Abington) as total_abington

, cast(sum(Abington) * 100.0 / max(grand_total.total_abington) as decimal(6,3)) as pct_abington

, sum(BelmontSt) as total_Belmont

,...

Restoring the [master] databases using another name is possible. In the past I myself have performed it on SQL2005 (if I recall correct) and SQL2008 (for sure) and a collegue...

Eric M Russell (10/20/2016)

---

So, you're saying that the users are entering values that are considered invalid due to their excessive length? You can avoid this by implementing check constraints on...

You can use the PIVOT funtion to do this. The PIVOT is clearly explained here: http://www.databasejournal.com/features/mssql/converting-rows-to-columns-pivot-and-columns-to-rows-unpivot-in-sql-server.html

Over here https://www.simple-talk.com/sql/t-sql-programming/questions-about-pivoting-data-in-sql-server-you-were-too-shy-to-ask/ can also some nice explanation be found.

If you still have doubts/questions about...

Do you mean the DBA must (re-)start the job if there...

I think you have two options:

First create a stored procedure to check if the "last run" moment of the applicable jobs meets the requirements of the schedule. You can use...

Just to make sure about your settings; can you post the output of the following query?

SELECT IS_SRVROLEMEMBER('sysadmin') as I_am_SA, * FROM sys.databases WHERE name = 'DB1'

I found a blog that describes a possible solution: Use PowerShell to Collect Server Data and Write to SQL[/url]

The most easy way to do it is using PowerShell. The invoke-sqlcmd (see URL invoke-sqlcmd) can be used to run a SQL command (or SQL file) against an instance. Put...

This is an old thread. You could better start a new one to get more and better response...

To migrate instances nowadays good scripting tools are available, especially with the Powershell....

just a simple internet search came up with the solution for...

You can check table [database_recovery_status] for the specific database. When value of column [last_log_backup_lsn] is NULL a FULL backup needs to be performed, before a LOG backup can be created.

SELECT...

data already previously loaded into memory on one server, but reading from disk on other server?

index fragmentation?

A movement of a SQL cluster group inside a WFC to another node is basically the same as an automatic failover. The SQL Server will go down on the active...