|
|
|
|
|
|
|
Question of the Day |
Today's question (by Xedni): | |
PARSENAME and Input Length | |
What will this result in?
declare @long_obj nvarchar(768) = replicate('a', 128) + '.' + replicate('b', 128) select parsename(@long_obj, 1) | |
Think you know the answer? Click here, and find out if you are right. |
Yesterday's Question of the Day (by MilesC) |
Partitioning Limits in SQL Server 2019 What is the partitioning limit for tables and indexes in SQL Server 2019? Answer: Tables and indexes are limited to 15,000 Explanation: The partitioning limit for SQL Server 2019 for tables and indexes is 15,000. This is true for all versions starting with SQL Server 2012. Before SQL Server 2012 the partitioning limit was 1,000. Ref: Partitioned Tables and Indexes - https://docs.microsoft.com/en-us/sql/relational-databases/partitions/partitioned-tables-and-indexes?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 - Development |
Programmatically create SSRS report as PDF - I would really appreciate some guidance on how to get vb code working in a SSRS report. Please refer vb code at end of posting. The code has been added to Custom Code (Report Properties, Code) and the code is called from a Text Box expression in the report. I have created a SSRS Data […] |
How to check if a particular table is being used right now? - I am completing an SP that will do massive deletes based on certain criteria from a dozen of tables. On average each table is tens of millions of rows, no permanent or tuned indexes on it (it is a staging-swap kind of tables, temporary transactional data holders) but occasionally heavy selects can be run against […] |
Running Total - I have a table that captures rainfall data approx every 10 minutes. I want to calculate a sort of a running total of the Last Hour's Rainfall and the Last 8 Hours Rainfall by Time. Last Hour's Rainfall = Sum(PrecipitationAmount) for the previous 60 minutes (PrecipitationMinutes is the number of minutes over which the PrecipitationAmount […] |
SQL Server 2016 - Development and T-SQL |
Need some help getting info of people logged in, but from the POV of NON-Sysadm - I modified a proc that returns a result set of all user emails to the application in question, with one column that displays a sundial if that user is logged in. I did this by doing a left outer join to sys.dm_exec_sessions Left join sys.dm_exec_sessions b on login_name = Su.name and program_name like ' |
I was asked to get rid of this Dynamic SQL for performance purposes. - Is it REALLY possible to bypass the @Where_Clause variable and make the below SQL non-dynamic? This is a statement from an SP that receives the below 5 parameters and dynamically builds the WHERE clause from them. I don't think it is possible NOT TO USE DYNAMIC SQL HERE, but double-checking with you guys. Thanks. -- […] |
Need explanation for below query what it does - @Date1 = '20150630' DATEADD(m,6, @Date1) < DATEADD(m,-12,GETDATE()) Ignore this, i got the answer after validating. |
Administration - SQL Server 2014 |
SQl Stored Procedure - View Tuning - Hi, We have a stored procedure which calling view which contains bunch of tables in sql 2014 and 2017 and it's slow. View contains roughly 100K records. I was looking view and based on joins and where clause i have created index but nothing gain as performance it's same. I tried following: Created Index based […] |
Development - SQL Server 2014 |
Using an Execute SQL task to return XML and store it in an SSIS variable string - Hey guys, I need to run a query in an execute sql task and return XML converted to Varchar(MAX) and store it in an ssis variable with a datatype of string. This is what I tried TSQL: DECLARE @Variable XML DECLARE @VAriableString VARCHAR(MAX) SET @Variable = (Select top 4 ID from [dbo].[Company] FOR XML […] |
SQL Server 2012 - T-SQL |
Concatenating to a string - I am trying to concatenate values into one string value and what i have so far is progress, but I want to encapsulate my variables with single quotes. The below gives me e.g. Karen,Cox,Oakland,MN,95573 when what I need is 'Karen','Cox','Oakland','MN','95573': p.firstname + ',' + p.lastname + ',' + i.city + ',' + t.stateAbbrveation + ',' […] |
SQL Server 2019 - Administration |
Gauging Performance Improvement after removing the unused indexes - Hi All, Removed some of the unused indexes. But, how to identify the performance improvement? Is there anyway to generate any metrics and giving that the managers? Regards |
SQL Server 2019 - Development |
PowerBI Report Builder - can it use/declare variables? - In SSRS, creating your own variables for use within your report is trivial... did MSFT leave this out of PowerBI Report Builder? In SSRS, I could create a dataset, and create a variable, and set the value using an aggregate for example (like a count of records in a dataset). I'm trying to do the […] |
Ensuring a randomly generated number is always 8 digits - Hi there I have inherited a piece of code which generates an Activation Code based on a seeded value as follows select cast (round(rand(31303258 * rand(DATEPART(millisecond,GETDATE()))) * 100000000,0) as int) where 31303258 is the seed or another 8 digit number Now what I have noticed is that not all the time, a 8 […] |
Reporting Services |
Programmatically create SSRS report as PDF - I would appreciate some guidance on how to get vb code working in a SSRS report. Please refer vb code at end of posting. The code has been added to Custom Code (Report Properties, Code) and the code is called from a Text Box expression in the report. I have created a SSRS Data Source […] |
SSRS 2016 |
SSRS 2016 - force page break - Hello, How it is possible to dynamically force a page break? for example: if the final page is on pagenumber say number 9 then have a page break before this page? Thank you |
Integration Services |
SSIS & Azure SQL database - Hi , I have an on-premise SSIS package which connects to SQL Server database(Source). On connecting source using onpremise SSIS need to connect Azure SQL database , after connecting Azure SQL database need to truncate the stage table first and insert the source data. On success of source data to destination table (stage table), need […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |