|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Default Time | |
How long does this statement pause execution?
WAITFOR DELAY '0:1' | |
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) |
Row and Page Compression Facts Which two of these are not true about Row and Page Data Compression in SQL Server 2019? Answer: System tables can be compressed., Compression allows more rows to be fit on a page Explanation: Of these items, system tables cannot be compressed, so this one is false. Compression does not allow more rows on a page, which is false. Compression does not change the max row size, and off row data is not compressed. Ref: Data Compression - https://docs.microsoft.com/en-us/sql/relational-databases/data-compression/data-compression?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 |
Locking and Blocking - Had update query running and select query also running at the same time , but getting time out expired for select query after waiting 30 sec to lock. Update query having no lock and resource consumption 17% IO and CPU. query plan having cluster index seek. Please help out to avoid time out expiry for […] |
CU25 cant install because of SSRS - I have a strange issue at a customer of mine that I have never seen before: on a SQL2017 there is a Reporting Services installed as well and it seems this one is blocking the patching of the DB service The version number 14.0.600.1669 is actually a version number coming from the Reporting Services that […] |
SQL Server 2016 - Administration |
Setting permissions for user to query DMVs without admin rights - What is a rightest way to grant such permissions to a non-admin user? User belongs to a group that has certain limited permissions on the server, with access to only several user databases. The user however needs to query DMVs in Master DB. Is it doable? and what is a good way to do it? […] |
the owner of BAK files - Hi All, How do I find out the owner of bak files ? There are some old bak files in D:\ that I want to clean up but thinking it is best to get the permission first thank you |
SQL Server 2016 - Development and T-SQL |
Exclude rows where value used in another row - I need to exclude data from a select query where the value of column A is used in other rows and the values of column B are different. Column A | ColumnB PhoneNumber | FirstName ------------|---------- 02038245161 | Jon 02038245161 | Henry 02038881121 | Jamie 02038881121 | Jamie From the above table I want to […] |
Is it possible to display XML data in SSRS report tablix neatly and fully? - How can I display XML data in SSRS report from a XML col in table just like it displays in SSMS? Is it possible to see it in SSRS report same way as on the screenshot? Right now it displays only as on the second screenshot, with wrapping, and not clickable. One row takes pages... […] |
hierarchy related query - Hello friends. I have a hierarchy table like this: Month empEntityID empID empName mgrID empEntityID1 empID1 empName1 empEntityID2 empID2 empName2 empEntityID3 empID3 empName3 empEntityID4 empID4 empName4 empEntityID5 empID5 empName5 empEntityID6 empID6 empName6 Month contains first calendar date of a month which shows which month a hierarchy set belongs to. Every employee is mentioned in first […] |
Development - SQL Server 2014 |
Perpetual Total - calculate difference between first and last value - Hi, I'm having to calculate a daily total tons from a continually incrementing number for a few products. I capture these increasing totals every 15 mins , I'm look at the best way to use a select query to achieve this, and thinking I need to use the first entry for the day at Datetime […] |
SQL Server 2012 - T-SQL |
get lastname,firstname, middlename as first 3 pipe delimiter last data no need - NAZARE|DEV|T||Current~NAZARE|DEV|T||Previous The above data NAZARE =Lastname , Dev=Firstname T= lastname . Could you please help me to writ in select statement using substring and charindex Pipe delimiter |
SQL Server 2019 - Administration |
Cross domain authentication - 'The target principal name is incorrect..' - I have problem with windows authentication. I have two domains (Lets say A and B), and server which is at the domain A. It is an default instance on the server and it uses AD account as an service account. What is a little bit odd is that there is a small difference between DNS of that VM and […] |
Entire Row to be Unique in the whole Table... - Hi Friends, I am having a need to implement a Business requirement where in each row in the whole table must be unique.Would be grateful if I can get any help from you in achieving this...Thank you in advance! Best Regards, Arshad |
SQL Server 2019 - Development |
Assign multiple fields to one variable - Hi I need to write a query / procedure that will create the following string - Column1Name=Column1Value;Column2Name=Column2Value...etc I have no clue on how to do that with sql. In c# or vb.net is quite simple and straight forward. It seems to me that in sql I have to know the columns names in advance, so […] |
FullText Search on PDF files - Hi We have an existing solution where we store documents in the database in FileStream tables. The users are allowed to search for content in these documents, using FullText and IFilters in combination we can do CONTAINS searches on document content. This has worked for years, and still do. Adobe has removed their download links for […] |
sp_send_dbmail: Failed to initialize sqlcmd library with error number -214746725 - This one is bugging the daylights out of me. We've got a stored proc that does some error checking then sends an email if there is an error. I can get it to work as long as I don't use the @query switch for sp_send_dbmail. As soon as I uncomment that, the code fails. I've […] |
Reporting Services |
High Report Export Volume - Hi There, I have a requirement to develop a solution to generate approximately 6,500 reports within a 2 hour processing window, and then export the reports in either PDF or Excel format to a secure ftp site. The source is SQL and the report data is from stored procedures. Currently this is being handled with […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |