|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
The Binary Cast | |
What happens when I run this code?
SELECT CAST(0x7e AS NUMERIC(10,4)) | |
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) |
BDC Containers What types of containers are supported in Big Data Clusters? Answer: SQL Server, Spark, and HDFS containers Explanation: A BDC (Big Data Cluster) supports SQL Server, Spark, and HDFS containers. Ref: What are SQL Server Big Data Clusters? - https://docs.microsoft.com/en-us/sql/big-data-cluster/big-data-cluster-overview?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 |
Table Partition in Sql Server - Hi Team, we have a table like 1.5 tb in size and around 800 cr records. I would like to make it as partitioned table. to make partition we need to drop and recreate primary and FK constraints will take more time. we need to perform this on more tables. so is there any approach […] |
SQL Server 2017 - Development |
SQL Query Help - CHARINDEX - Need query help. create table #tblTest1 (ID int, SName varchar(50), Type varchar(10)) INSERT INTO #tblTest1 values (1,'abc/efg','OS') INSERT INTO #tblTest1 values (2,'xyz/tgf','OS') INSERT INTO #tblTest1 values (2,'tgf/xxx','OS') INSERT INTO #tblTest1 values (3,'ccc/ppp','OS') INSERT INTO #tblTest1 values (4,'ddd/tqm','OS') INSERT INTO #tblTest1 values (5,'mpg/eee','OS') create table #tblTest2 (SName varchar(50)) INSERT INTO #tblTest2 values ('efg') INSERT INTO #tblTest2 […] |
SQL Server 2016 - Administration |
Merge replication can't update trigger at subscriber Msg 21531, Level 16, State - I have a trigger (merge replication) at a subscriber that does not match what is on the publisher. Publisher is correct and I need to get this pushed to the subscriber. When I update the trigger on the publisher query reports successful. Looking at SSMS Profiler I see calls to sys.sp_MSmerge_ddldispatcher but trigger is not […] |
SCOM alert offline/recovery pending/suspect... but DBs seems fine - Hello experts, We are using SCOM to monitor SQL Server AOAG, and I am having trouble resolving this alert: Database is in offline/recovery pending/suspect/emergency state I use the alert details to check the status of the databases on each of the AOAG replicas, as well as the Always On High Availability Dashboard. The dashboard is […] |
What Should be...? - Dear friends, Using Always On in our corporate site, we have 3 nodes deployed, our main database backup is based on images of that virtual machines, but constantly I have databases requesting transaction log backups, what role should have a normal backup of transaction log files vs virtual machines images backup, our management team has […] |
Cannot connect after Availability Group automatic failover - Hi We have a SQL Server setup with Availaibility Groups, in the cluster we have four nodes, two in one datacenter and two in another datacenter. There are four AGs on these cluster nodes, each primarially on one of the four nodes, with one other node in the same datacenter for syncronous HA and the […] |
SQL Server 2016 - Development and T-SQL |
How to grant only read(Select) permissions to the Group of Users - I have a business requirement where Business Users are all available in Group "TradingBusinessUsers" , Now i want to grant select permissions to all tables for the users in the group "TradingBusinessUsers" and also users are allowed to create table on their own Self-schema and manage their tables. Can anyone help me to solve this […] |
Is it possible to display Date in between in cube without multiplying the Data? - Ahoi, I have to display "discount" as a measure in my Cube. The basic structure is: DateFrom DateUntill DiscountMeasure The request is: Have a Date and display the DiscountMeasure. My question is: Is there a better way to solve this than creating a dataset for each day between DateFrom and DateUntill? I was hoping […] |
SQL Server 2012 - T-SQL |
Need help formatting BCP output - Hello, I have a bcp script that generates stored procedure code output as shown below. bcp "select RTRIM(LTRIM(c.text)) FROM sys.objects AS o INNER JOIN sys.syscomments AS c ON o.object_id = c.id WHERE o.type = 'P' AND o.name = 'sp_ic9av0_dx_length'" queryout "\\dbserver1\j$\Backup\NG Sps\sp_ic9av0_dx_length.sql" -t -c -r "\t" -SServer1 -T -dMyDb There is a formatting issue in […] |
SQL Server 2019 - Administration |
Update - I have a Use case like. We migrated around 1000 millions of rows into around 5-6 tables. client requirement frequently change to update some columns. Is there any best way to Update those tables other then Batch/looping updates. We tried disabling all the index but still it's taking too much time. Even we have 5-8 […] |
Page File. Set Value, or let Windows Manage it ? - I friend at another company said they got an out of memory error on their Production SQL server. It has 24 Gig of RAM and a 4 Gig page file. Their hosting company said they can increase the page file to a set value, or let Windows manage it. If Windows manages it, is there […] |
SQL Server Hardware Recommendation - Hi, I'm looking for a recommended Hardware Spec to run SQL Server 2019 Enterprise on. Our software vendor has suggested the below, but was looking for other people's thoughts. Our Database is currently sitting on a SQL2000 database - it's around 300GB in size and is accessed by around 90 people at a time. […] |
SQL Server 2019 - Development |
DateDiff for only @p_start_date and @p_enddate - So I am trying to get the datediff for parameters selected, even though the 2 dates could span 60 days, for an example I have 2 dates available(2018-01-05 11:08:00) and unavailable (2017-10-30 05:05:00) I only want the datediff where @p_start_date = 2017-12-01 and @p_end_date = 2017-12-31 those are the selected parameters. |
SQL Collation to match IBMi - In SQL, these items sort this way INV175 INV190 INVB03 INVB04 On the IBM iSeries, they sort. INVB03 INVB04 INV175 INV190 Is there a SQL Collation I can use in a query to make a SQL Select ORDER BY match the IBM Sort ? EDIT: I found this in an old post, which seems […] |
Integration Services |
Access Files Stored in Box.com - Has anyone created an SSIS package which grabs data from one or more files stored on Box.com? I would be interested in hearing how you got on. Did you get the Box API working from a script task? Any issues adding DLLs to the GAC? |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |