|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Cloning MSDB | |
Can I execute this code in SQL Server 2022?
dbcc clonedatabase(msdb, msdb_clone) | |
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) |
Converting to Bits I have this code: CREATE TABLE BitTest( insertdate DATETIME DEFAULT GETDATE(), a INT) GO INSERT dbo.BitTest (a) VALUES (0), (1), (0), (2), (5), (0) GO ALTER TABLE dbo.BitTest ALTER COLUMN a BIT GO What happens when I run this? Answer: This works, and all 0s stay 0s, and all other values convert to 1s Explanation: This works, and all non-zero value are converted to 1s. Ref: Bit - https://learn.microsoft.com/en-us/sql/t-sql/data-types/bit-transact-sql?view=sql-server-ver16 |
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 2016 - Development and T-SQL |
Opening an SSIS package created in 2016 with a later version of Visual Studio - I have SSIS packages created in SS2016(i.e. 130). If I use a visual studio version newer than the SSIS package, will it convert the package to a later version? I would think if that's the case then i will have a problem running this upgraded SSIS Package because I'm still running SS2016. I would think […] |
Administration - SQL Server 2014 |
SQL server disk block size formatted as 4KB runs slow - Hello All, One of my SQL server 2014 all the disk are formatted as 4KB. I see Microsoft recommends to have 64KB. I feel the query running slow and most of the query waits shows as two waits 1. PAGEIOLATCH_SH 2.CXPACKET and overall server wait also same. Please share your experience. |
SQL Server 2019 - Administration |
Failover Cluster configuration in windows 2019 for 2 subnets - Today I am in critical situation for Production server build with failover cluster for 2 different sub nets with 3 nodes cluster. SQL1.domain.com xx.aaa.bb.cc1 SQL2.domain.com xx.aaa.bb.cc2 DR.domain.com xx.aa1.bb.zzz While validating a Failover Cluster over two member servers I get the following two errors: Connectivity to a writable domain controller from node SQL2.domain.com could not be […] |
Server_principals sid changed compared to database_principals sid for AD-group - Yesterday I configured some new databases and granted a couple of AD-groups auth to perform their stuff. Today, the admin-group could not create objects in their database. Ad-group membership was OK Account was not locked out. Only thing I did after this initial setup is upgrade the SQL Server 2019 to CU25, upgrade the Windows […] |
SQL Server 2019 - Development |
find the number of values less than the current row - Hi everyone I am working on a query where I need to find the number of values that are less than the current row's value going back X days. For this example, let use X =5 but it can be any number. Sample data: Explanation: Start at Day 11. Day 11 value is 42. I […] |
over clause - Posting Error please ignore |
how to speed this query up? - hi everyone I have a query I use at work. I use percent_rank to rank sales by company for the last 50 days. For example, if I run the query today then I want to look at the last 50 days of data (including today) and then rank the sales for those 50 days. So […] |
Pre-defined filters for stored procedures - Hello all, I have defined a set of filters and assigned each set a FilterID. I want to pass this FilterID to a stored procedure and filter the results accordingly. My working example inserts the broadest set of data into a temp table and runs conditional deletes to get the appropriate results. Before I delve […] |
Reporting Services |
Tablix shows only the first entry when several entries exists with the same time - Hi @all, I'm using a tablix in SQL Server 2019 Reporting Service to show some entries from a SQL database. It works fine and query is very simple. Select [TimeStamp], [Data1], [Data2], [Data3] From Table Where [TimeStamp] between @Start and @End But there is an issue when the TimeStamp value is identical for some […] |
Integration Services |
DB Native versus Win Authentication with SSIS Packages and Deployment - Hi there, I have done a migration of Informatica PowerCenter ETL project to MS SSIS project using Visual Studio 22 Everything is now working fine when I run the packages one by one within the VStudio on my laptop. The next step would be to deploy my project to the Sql Server SSIS Catalog. I […] |
SQL Server 2022 - Administration |
facing deadlocks issue from last week - I am facing few deadlock issue recently and when i tried to debug the issue using the XML file generated from the Extended event, i was not able to figure out the exact issue. The text seems very generic to me. Below the content of the XML file […] |
Alway on Availability group cluster less - Hi for dr purposes i need to setup an on prem db in replica with a db on azure on a iaas vm i'll use sql always on availaility group in clusterless ag mode , if i need to test the secondary node do i have to do a failover? what about the fallback? […] |
SQL Server 2022 - Development |
Table partitioning questions - We have state of the art latest and greatest managed SQL Azure MI Business critical. Table has 84 M rows, transactions table with data from 2019 to 2024 and beyond, I was asked to implement partitioning to improve performance and management , I read around and will use the GUI and implement partitioning by month […] |
Analysis services tabular models - how to detect tables which have had errors - I am using a query (using TMSCHEMA) to derive the tabular tables to be processed. The aim is to process as much as possible in an iterative way and skip the ones which have an error i nthe processing run. Running the query and execute the processing works with a stored procedure. The query works […] |
SQL Server Count Query - Hi All, I have a data in column A in where in need to achieve the count which I have mentioned in column B. Please find the attached excel dataset for reference. Thanks |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |