Here's a few of the new posts today on the forums. To see more, visit the forums.
|
| SQL Server 2017 - Administration |
| Alwayson Availbility group extended to Azure?.. - Hello, Can databases on-Premise Alwayson Availability group of SQL server 2017 failover to Microsoft Azure SQL database (PaaS)? Or it has to be IaaS? We don't have Azure VMs (IaaS) but only license for Azure SQL databases (PaaS). And How about Basic Availlbity group on Standard Edtion? thanks alexsunny |
| SQL Server 2017 - Development |
| SQL Query Help - display records - Need help with Query. CREATE TABLE #tblTemp (IName varchar(50), ICategory varchar(20), IValues varchar(10)) insert into #tblTemp values ('JSmith','Bar1','1QT') insert into #tblTemp values ('JSmith','Bar1','2QT') insert into #tblTemp values ('JSmith','Bar1','3QT') insert into #tblTemp values ('JSmith','Bar2','1QT') insert into #tblTemp values ('JSmith','Bar2','2QT') insert into #tblTemp values ('JSmith','Bar2','3QT') insert into #tblTemp values ('JSmith','Bar3','1QT') insert into #tblTemp values ('JSmith','Bar3','2QT') insert into […] |
| Stored Procedures and Entity Framework not returning columns - I have a developer using Entity Framework and the metadata isn't returning for some stored procedures. Specifically ones that use Temp Tables. I've seen some EF articles about using SET FMTONLY OFF to get the metadata but I would prefer not to touch this. Are there any examples/methods anyone has come across to resolve this […] |
| Merge statement with partial part of the table. - Hi, I have a very big table and I need to do a merge. if the primary key and the record source match then I need to update one column, otherwise I need to insert. I really dont need to do the whole table, but only the part when the data is bigger than a […] |
| SQL Server 2016 - Administration |
| SSRS 2016 giving 500 error - Hello! I am getting this intermittent issue when browsing the report, this error goes away once I refresh the browser. This seems to be happening when accessing report through the load balancer (https://) only Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 500 […] |
| Backup taking too long - SQL Server 2016 - Backup is taking too long to complete all of a sudden, this is the wait_type and time shown for the backup. wait_type :ASYNC_IO_COMPLETION wait_time : 53127671 This DB server has more than 10 CPU and 96 GB RAM, SQL is using max memory of 92 GB. |
| SQL Server 2016 - Development and T-SQL |
| Determining whether a parameter has been established. - I have a ssrs report with 6 parameters 4 or which are cascading and one parameter (pTimeZoneID) that drives the "Time Zone" in a dynamic OLE DB connection string. Need to set the Default value in the pTimeZoneID to a static "Time Zone" in order to use the data source to populate the 4 cascading […] |
| Administration - SQL Server 2014 |
| Need to create a job for dynamic execution on another server - Hi all, I need to create a job to dynamically script out indexes and some other objects from Server A and apply them on Server B. They are linked through a Linked Server. But how to construct the job? I know how to build dynamic code, but how to save its output, and how to […] |
| sp runs in 1 second sometimes and sometimes it takes forever - sp runs in 1 second sometimes and sometimes it takes forever and returns null even though there is data thought it was parameter sniffing and started using option recompile..but still runs the same. What could be the reason for this behavior? Thanks! |
| SQL 2012 - General |
| SQL Server DR Test - Hi all I am pretty new with SQL Server and I have some doubt about doing DR tests with SQL Server. I have around 25 database running in SQL Server 2012 Standard Edition with Log Shipping setup in another Data Center. I have to do a simulation DR test, breaks Data Center communication, […] |
| SQL Server 2012 - T-SQL |
| deleted duplicate post - deleted duplicate post |
| SQL Server 2019 - Administration |
| Failover Clustering IP's - For a 2 node active/passive cluster on Physical servers with shared storage. I am trying to setup Failover clustering for two nodes. I am looking for the required IP address needed. So below is what I came up: I need total of 3 IP addresses along with the virtual server names 1 IP address for […] |
| SQL Server 2019 - Development |
| query - Hi i have 3 table that need to find out which id missing two tables TABLES: Main,table1 and table2 compare with Main-table against the table1 and table2 which id is missing that two table show |
| Joining 2 select results into a single row - select( select name,enabled, case when enabled = 1 then 'active' else 'notactive' end as JobStatus from msdb.dbo.sysjobs where name='JobA'), (SELECT CASE WHEN EXISTS ( SELECT name FROM msdb.dbo.sysjobs WHERE name = 'JobA' ) THEN 'Exists' ELSE 'Does not Exists' END as 'JobAPresentAbsent') Error:Only one expression can be specified in the select list when the subquery […] |
| General |
| Keeping a record of Scripts run - Hello I have a real issue with the scripts that are being run on our systems - database. Vendors pass various scripts through the Apps team so I have no problems with their legitimacy, but I have a real problem in keeping track of what was run, when, by who (which DBA). More often these […] |
