|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Serverless Compute Cost | |
I define my Azure SQL Database Servless edition settings like this: Max vCore: 8 Min vCore: 4 This should ensure good performance for my system. If the database is in use, and not paused, what would my charge be if my usage during an hour was 1 vCore worth of work? | |
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) |
Unique Clustered Columnstore Index In SQL Server 2019, can I create a unique clustered columnstore index? Answer: No Explanation: No. A columnstore index is designed to be organized by column and achieves it's benefits from the compression of the same values being used over and over. Columnstore indexes do not allow constraints, including unique constraints. Ref: CREATE COLUMNSTORE INDEX - https://docs.microsoft.com/en-us/sql/t-sql/statements/create-columnstore-index-transact-sql?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 |
DBCC CHECKDB output - I ran a DBCC on a database and it found some anomalies. Just looking for some insight as to how to interpret this output (the part of the output that was in red), what do you think? Do these indexes found below need to be rebuilt or reorganized, or perhaps I need to rerun DBCC […] |
SQL Server 2017 - Development |
View will not run from System Databases - I'm planning an upgrade to SQL 2017 standard edition from 2008 workgroup Edition. On a new Server with new OS. I'm restoring the DBs to the new server and keeping their compatibility levels (100). After restore I'm updating Statistics. The queries run slower on the new server. The new Server is not live so I'm […] |
SQL Server 2016 - Administration |
Why is sys.master_files showing the size of RBS files as 0? - Dear Everyone I hope you are all safe in these strange times. I am trying to find the size of the database datafiles, transaction log files and RBS files in my SharePoint database where filestreaming is enabled and I tried to run the query below but I get the size of the RBS files as […] |
SQL Server 2016 - Development and T-SQL |
No record in an UNION query - Sorry if the title is unclear. The following query is used in an Excel pivot table. It is an union of Cie1 and Cie2 companies. The main criteria is to show the back orders (b/o) I would like that as soon that either one has a b/o, both Cie1 and Cie2 will show, Currently, only […] |
Sanity Check of (possibly) over-complicated query. - Background: We have a Document Management System which currently has 10 file servers configured in the DMS Database table DOCSERVERS. Relevant Columns: CREATE TABLE [MHGROUP].[DOCSERVERS]( [DOCSERVER] [NVARCHAR](32) NOT NULL, --internal DMS fileserver name reference [OS] [NVARCHAR](32) NOT NULL, [LOCATION] [NVARCHAR](254) NOT NULL, --\\hostname\share [ROOTPATH] [NVARCHAR](254) NULL --\root dir ) The user table DOCUSERS stores all […] |
Sum Pivot by Dynamic Quarter - i have a report to create a prediction for 12 months (yearly prediction by month). example when will be the shipment date is base on input from user. the report will run by month. for example this month is July, shipment will only show July onward. i manage to create the dynamic pivot. how can […] |
Administration - SQL Server 2014 |
Primary Data Files - Good day experts, I added a second mdf file to my database but the second file is not writing any data. Am i missing something? i am using standard 2014 edition and the settings are as below: Thanks for your advise |
Development - SQL Server 2014 |
SSRS NaN Error - Good day Gents, I have an SSRS report that I'm working on, and one of my expression is returning a "NaN" when dividing by zero. Can you guys provide some insight on a workaround to the "NaN"? Below is my expression: =(Sum(Fields!Reciept.Value) + Sum(Fields!Balance.Value)) / Count(Fields!VisitID.Value) |
In where condition use column value which contains column name - Hi Team, Greetings! I have below table. let table name =Emp I need to query in the table like below. select * from Emp where (Here instead of writing country='India', I want to use the column business_rule directly so that i can get the records ) Thanks in advance! |
SQL Server 2012 - T-SQL |
Large difference in Actual rows vs Estimated rows - I have a small query between 2 tables that i can't seem to figure out why the actual vs estimated rows is so far off. The actual is 66466, the estimated is 1268.13. What info do you guys need to help me out? Thanks. Edit: attaching query plan for a start. |
SQL Server Newbies |
How to Setup/Configure AlwaysOn Availability Group in SQL Server - Hi, I am learning how to setup and configure the AlwaysON Availability group and have couple of questions. 1 - Is it possible to setup/do this on single windows machine. I wanted to do this on my own lab which has 2 named instances running. 2 - Do I have to install Windows clustering services […] |
Reporting Services |
SSRS 2017 Report parameters show on the top of the page not left - Hi I am migrating reports from SSRS 2012 to SSRS 2017. In 2012 the report parameters show up on the left of the page, in 2017 they show on the top. Is there anyway to specify the top of the page for parameters? Any help is appreciated Thanks |
How to do a Matrix properly - Hi everyone I have some events data with related delegates. The events have two parameters (Category and Region - an event only has one of each of these), I've created datasets and parameters for these lists and they appear to be working fine. I have a row group of Event Name and a column group […] |
Integration Services |
Binary(Document) Extraction using SSIS - derived column - Hello all - I'm reaching out for some pointers regarding a task I have pending: I have a specific task whereby I have to extract some files out of a database(Varbinary) column. I've done this on a couple of occasions using an SSIS package - albeit in a pretty simplistic manner. For all intents, it […] |
SQLServerCentral.com Website Issues |
"Stairway Series" page exposes article revisions - I clicked on the "Stairway Series" link below an article title and it brought me to the main "Stairways Series" page: https://www.sqlservercentral.com/categories/stairway-series As I scrolled down, I noticed that there were 3 entries for one of my articles: "Stairway to SQLCLR Level 2: Sample Stored Procedure and Function". One of them is listed as "Stairway […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |