|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Azure Storage Copies | |
How many copies of my data are created with Locally redundant storage (LRS) in Azure Storage, the cheapest option? | |
Think you know the answer? Click here, and find out if you are right. |
Yesterday's Question of the Day (by Steve Jones - SSC Editor) |
Database Compression Settings I have a new SQL Server 2019 database. I want to ensure that all indexes in any database are compressed using SQL Server data compression. What should I do? Answer: Add the DATA_COMPRESSION option to each index create statement Explanation: Data compression works at the table and index level and cannot be set for an instance or database. You can compress all indexes if you include the option in all index statements. Ref: Data Compression - https://docs.microsoft.com/en-us/sql/relational-databases/data-compression/data-compression?view=sql-server-ver15 |
Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Administration |
What other useful DBA reports do you suggest? - What other useful DBA reports do you suggest? Maybe something we would run every month or so to check that our environment is configured/running optimally. We have these so far: see screenshot. I also already have (adding soon) certain reports on block leaders and Waits report based on sp_whoisactive, report on 'Worst of the Worst […] |
Availability Group Listener - I am working on creating listener however, the subnet is full so I can't get the ip address as server IP range. What other options I have? |
SQL Server 2017 - Development |
Speeding up Query - Hello, I am new to sql and learning my way around writing views for our company. Any tips and tricks to make this query a little faster or streamlined? SELECT TOP (100) PERCENT ord.orderid, ord.lt_orderid AS LTOrderID, ord.datetimecreated, ord.BookedByDT AS DateTimeBooked, us.firstname + ' ' + us.lastname AS BookedByStaffer, ord.VoidDT AS DateTimeVoided, ord.CancelledByWho, ord.voidreason AS […] |
Need help sorting based on 2 different column DateTime - I've this table and data as following, CreatedDate CANNOT NULL. LatestRepliedDate can NULL CREATE TABLE [dbo].[IncidentMasterSimulation]( [Id] [int] NOT NULL, [IncidentDate] [datetime] NOT NULL, [IncidentDateDisplay] [nvarchar](100) NOT NULL, [HowLong] [nvarchar](100) NOT NULL, [IncidentNo] [nvarchar](100) NOT NULL, [ProjectName] [nvarchar](100) NOT NULL, [Categories] [nvarchar](100) NOT NULL, [PriorityLevel] [nvarchar](100) NOT NULL, [IncidentDescription] [nvarchar](100) NOT NULL, [CreatedBy] [nvarchar](100) NOT […] |
SQL Server 2016 - Administration |
How to get a SQL/CSV list of SCOM alerts and rules - Hello experts, I've been tasked with tuning SCOM alerts for our database environment. Getting the alerts in emails is a little overwhelming and hard to manage. I don't see a way to export a list from the SCOM console, where I have to click through alerts one by one. Does anyone know how I can […] |
Bulk Copy Program (BCP) from the ODBC layer - I am trying to locate some documentation, some where, any where, about ASYNC_NETWORK_IO with BCP inserting rows. the wait appears in the server monitor of a customer, we have attempted to explain the wait is normal while the client is using bcp_sendrow and before the bcp_batch or bcp_end functions are called. the server has bcp […] |
SQL Server 2016 - Development and T-SQL |
Dictionary Lookup - Hi I have hundred million ID, NAME pairs stored in SQL Server as a table that is accessed by C# code, which has a responsibility to lookup NAMEs corresponding to million IDs at a time. C# code has these million IDs stored in an array, before invoking SQL module. Columns of the SQL table: […] |
SQL - SUBSTRING combined with CHARINDEX not returning desired results. - Hello Friends, I'm in need of some help here please. I'm trying to extract a certain part of a string. I can extract the desired part from first example below by using the using. RIGHT(SUBSTRING((ORGPATHTXT),CHARINDEX('/',ORGPATHTXT) - 8, LEN(ORGPATHTXT) - CHARINDEX('/',ORGPATHTXT )- CHARINDEX('/',ORGPATHTXT ) - CHARINDEX('/',REVERSE(ORGPATHTXT))),8) The problem is that if there is a location before […] |
Development - SQL Server 2014 |
how to get quantity from yesterday 6pm till today 6pm - Hi, I am looking to create a case statement that gets different quantities. For example, I would like to see how many orders were created between 6pm yesterday till 6pm today, how much created between 3pm yesterday till 3pm today, and how much was dispatched between 3pm yesterday till 3pm today. I created this case […] |
SQL 2012 - General |
Database Integrity Issues - To avoid a lot of contention during peak business hours we separated our integrity checks into weekday and a weekend run. During the week we do a PHYSICAL only and on weekends when activity is lesser, we run a full blown integrity check. While it appears to be inconsistent, sometimes we get errors for a […] |
Rounding problem (?) using DATEDIFF (minutes) - I have a query that is using DATEDIFF to calculate the number of minutes, of course as an integer, but I may need the extra precision of showing this as a decimal (?). Also I'm looking for a way of summing the time based on "EmpID" (using CTE?): SELECT T1.[EmpID], Convert(Datetime,T1.[Time]) AS [Time], MIN(Convert(Datetime,T2.[Time])) AS […] |
Data Access in DBMS and RDBMS - Hello All, I want to know which one is better for Data Access point of view between DBMS and RDBMS? Yesterday I found this source and according to it In DBMS, you can access only a single file from a single database but not an idea about DBMS? Can anyone explain me with some examples? |
SQL Server Newbies |
Performance degradation with a particular stored procedure - Hello, I'm attempting to make sense out of a performance issue I'm seeing with one of our applications. Basically, there's a screen in the app that displays equipment records, and a search filter that our users can make use of. Throughout the day, several users are running searches on this equipment screen. Some of these […] |
SQL Azure - Administration |
Enable Automatic tuning sur instance Azure - Hello , Is the activation of the Automatic tuning function on an Azure SQL manager instance equivalent to the recompile operation If I activate it SQL will calculate the execution plan for all the ad-hoc queries suddenly will generate more consumption on the CPU side Is it recommended to activate this function on the Azure […] |
SQLServerCentral.com Website Issues |
Send private message to another site member - I wish to send a private message to another member of this site...been away for a few years and have forgotten how to do this. All advice is appreciated. Thanks JLS |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |