Reporting service Edition for 2017 - I understand reporting service is a separate download for SQL 2017. I go to the download site there is only...
need help - hello all, I have 3 tables. employee , division and empDivMap. The employee table is the master table of employee data. The...
AlwaysOn Diagram - Evening All, I am wanting to create diagrams similar to the following: https://smartbridge.com/wp-content/uploads/sbblog_sqlserverdatabases1.gif What would the best software to recreate that be? Cheers Alex
Planning for a server - Hi, this is a very general question, and I need a baseline idea of where to go. Getting into too...
Backups and AlwaysOn Availability Groups - Hi, I'm sure this is an easy answer for many of you but, when setting up AlwaysOn Availability Groups for the...
t-SQL Solution to backup and restore - Dear all, I was requested by my company to create a solution that is able to backup a database from PROD...
ApexSQL Monitor - Good afternoon, Has anyone ever used or have an opinion on the ApexSQL Monitor tool? I am currently evaluating the product...
Migrate SQL Server to new server - Hello All, I would like to upgrade my SQL Server 2012 to SQL Server 2016. I created new machine and i would...
Deny delete for some users - Hi, I have an application that there are mystery deletes occurring (long story). My users would like if there was a...
Database Corruption - Hi All, I hope that I could had some Help concern to a issue that currently I am facing. So I have...
load data into 3 separate tables using tsql . - Hi All, I have below table. Basically, I dumped testddata as is to a table. now i want the data...
Dynamic Pivot/Unpivot - Hello, I have a table like below, where headers of columns and rows are dynamic (this is a result of query)
Understanding of Unique Index - I appreciate it might be a trifling question for most of you, but... I have a primary key on columns A,...
Table Structure of Monthly Data - I'm curious what everyone thinks is the best way to store data where the history of aggregated data for an...
Changing NVARCHAR to VARCHAR... - Dear Experts, As part of tuning on a database , I want to reduce the high physical reads by reducing the number...
Join two tables with complex derived keys that don't match - Guys, I need to join two tables together - Master and Detail Master Table: ID =7000776601*1*6994 Code=P*W*S Instances=6994ý12510ý12874ý13245ý13609ý13973ý14337ý14701ý15009ý15072ý15436ý15800ý16164ý16528ý16899 Details Table
Dynamic variables in SQL server for HTML - I am trying to recreate and automated email. The email has gone from having, one column with headers and one...
Reporting Services will not start with a .NET 2.0 Runtime Error - .NET Runtime version 2.0.50727.8762 - Fatal Execution Engine Error (000007FEF983104E) (80131506) Receiving this error as of this morning after Networking did some...
SSIS: Insufficient disk space - Hi All, I am getting below error while executing SSIS package through job: There may be error messages posted before this with...
Data row does not have a matching index row in the index - Hello, I have this problem. At monday found this, so drop and recreate index, then execute dbcc check and without problem. Today...