|
|
|
|
|
|
|
| Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
SQL Server Ghosts | |
| For Halloween, what are ghost records? | |
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) |
Slip Streaming Installs What does a slipstream installation mean? Answer: This means installing a new instance along with various CU patches together. Explanation: From MSLearn: Slipstream installation is the process of integrating cumulative updates (CUs) into the SQL Server setup process. Ref: Slipstream installation for SQL Server - https://learn.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-using-slipstream?view=sql-server-ver17 |
| 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 - Administration |
| SQLPS and syspolicy_purge_history job - The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie, not in the path select Agent_exe from msdb.dbo.syssubsystems where subsystem = 'PowerShell' nor anywhere to be found on these machines. As a result, syspolicy_purge_history fails. And in fact, the job's status is "suspended", and I can't even stop it. I am […] |
| SQL Server 2019 - Development |
| how to write this query? - Hi everyone I am a bit stuck on how to write this query. Below is test data: drop table if exists #price_cutoff drop table if exists #nr_data drop table if exists #nt_data create table #price_cutoff ( [SYMBOL] [nvarchar](10) NOT NULL, [TRADE_DATE] [date] NOT NULL, [NR_PRICE] [float] NULL, [NT_PRICE] [float] NULL ) create table #nr_data ( […] |
| Line number in error message doesn't match up with line number in code - Hi everyone I have a 1000 plus line query and I am getting an error: Msg 8115, Level 16, State 6, Procedure dbo.TestQuery, Line 1036 [Batch Start Line 2] Arithmetic overflow error converting float to data type numeric. It says line 1036 but when I go to that line I get something that can't possible […] |
| Analysis Services |
| Automatically generate tabular model partitions - Hi. I hope someone can give some useful suggestions. My workplace have a suite of SSAS tabular models. They used to be created in compatibility level 1103. We then used a free piece of software with them called Partition Manager (which was a free download from Codeplex, to show it's age!) to dynamically generate partitions […] |
| Anything that is NOT about SQL! |
| Are things getting beyond reason? - My wife apparently ask her phone a question and below is what she sent me in the answer to her query. I look at this and can only shake my head in wonder. If this is AI in action, I think it's time to kill it off. Imagine the bandwidth required to move this much […] |
| Editorials |
| Be Wary of Data - Comments posted to this topic are about the item Be Wary of Data |
| I Love Editorials - Comments posted to this topic are about the item I Love Editorials |
| The Journey to PostgreSQL (or anything) - Comments posted to this topic are about the item The Journey to PostgreSQL (or anything) |
| Article Discussions by Author |
| Locking Hierarchies - Comments posted to this topic are about the item Locking Hierarchies |
| Why Indexes are Important Beyond Faster Execution of Queries - Comments posted to this topic are about the item Why Indexes are Important Beyond Faster Execution of Queries |
| Powershell script to generate SQL server Inventory in CSV format - Comments posted to this topic are about the item Powershell script to generate SQL server Inventory in CSV format |
| Database Ledger in SQL Server 2022 - Comments posted to this topic are about the item Database Ledger in SQL Server 2022 |
| Azure SQL Database MAXDOP - Comments posted to this topic are about the item Azure SQL Database MAXDOP |
| Building a RESTful API with FastAPI and PostgreSQL - Comments posted to this topic are about the item Building a RESTful API with FastAPI and PostgreSQL |
| SQL Server 2022 - Development |
| repeat results without loops, MSSQL2005 Express - hello everybody, new here and this is my first question I have a table contains: Name, Id, joinDate My question is that: I need a query to list all years between current date and joinDate, as the following as instance: Id------------------------Name----------------------empDate 1--------------------------John-----------------------6-8-2020 result: 1--------------------------John-----------------------6-8-2021 1--------------------------John-----------------------6-8-2022 1--------------------------John-----------------------6-8-2023 1--------------------------John-----------------------6-8-2024 1--------------------------John-----------------------6-8-2025 Thanks in advance. |
| |
| ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |