|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Cleaning Your Tables | |
What does DBCC CLEANTABLE do? | |
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) |
Statistics Profile What does SET STATISTICS PROFILE ON do? Answer: Gives the actual number of rows and number of executions for each line that is returned by the SHOWPLAN_ALL results. Explanation: This setting will return a result set that contains all the data from the SHOWPLAN_ALL results, but with two additional columns:
Ref: SET STATISTICS PROFILE - https://docs.microsoft.com/en-us/sql/t-sql/statements/set-statistics-profile-transact-sql?view=sql-server-2017 |
Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
Bulk Update From List - I would like to update the EmailAddress column of a database table with emails from a list . So basically I have two lists, Emails and Username lists. I want to check each value of the UserName column against the Username list. Then I would like to update the EmailAddress column with the email from […] |
I need help to build a query with wildcard and strings. - Hello I need a query to bring all the account (6 varchar) when the user type into the field the three first numbers or full account I have account 100101, 100102, 100103, 235101,235102, When user type 100 all the 100's will be in the report. If anyway I was using wildcard but it didn't work. […] |
Combing FailOver Cluster Instance with AlwaysOn Availability Group for DR - Hello Folks, I've a requirement to add AlwaysOn for DR on top of an existing FCI (Failover Cluster Instance). Please provide detailed steps on how to configure this. Any issues on this setup. Existing FCI - 2 Node Active-Passive (Physical Servers) Environment: SQL 2014 Enterprise / Windows Server 2012 R2 Many thanks! |
SSRS - Display field value based on user - Hello, WHile using SSRS, I only want to display a fields data value if the user is a specific person, otherwise I want to set the field value in the Tablix to "0'. I believe the following expression would be correct but isgenerating an error message. Can someone provide some insight? Many Thanks in advance! […] |
QotD: 'Answer This' link still active after answering question - With the new interface, the only way I seem to be able to get back to the list of questions is to click on QotD in the menu bar, but then many of the questions I'd already answered (correctly or incorrectly) appear as unanswered, i.e. the 'Answer This' link is active. I'm using Chrome […] |
Deleting or updating two rows based on a value of one of them - Hi I need help in updating or deleting two rows based on the value of one of the columns. For example, please note the sample data I have provided. CheckNumber 20009, I have three rows. two of the rows have a value of 1 in removed. In this case, I need to update to any […] |
Add Zero(0) to columns based on Min and Max value of the record. - Here min Calendar year is 2010 and max Calendar year is 2013 How to add Zero to employes who does not have that year Input sample: Salesamount CalendarYear Employee 637000 2010 282 3440000 2011 282 4415000 2012 282 3294000 2013 282 1898000 2011 291 4985000 2012 291 3631000 2013 291 478000 2012 296 1209000 2013 […] |
XMLAErrorOLE DB error: OLE DB or ODBC error: Invalid column name - I recently added two new measures into my cube, the measures were called AssetValueUSD and InvoiceValueUSD, I also added them to my perspective and my partition query. When I then processed the cube I got an error XMLAErrorOLE DB error: OLE DB or ODBC error: Invalid column name 'AssetValueUSD'. Any idea what I've missed? |
Change of a data flow arrow to point to different component ? - It doesn't seem to be possible to change a data flow arrow to point to a new component ? i.e. If I want to insert a new "Row Count" component between a Slowly Changing Dimension component and an "Insert Destination" component for an existing ETL process. Or is there some "trick" that can allow me […] |
Dimension property : OrderBy Key - Hi guys, I'm a newbie in development of Sql Server Analysis, I would like to ask some guidance. It's a basic really. I have a Date Dimension with one of the attribute is Month. Question is in that property OrderBy there are 4 options : Key Name Attribute Key Attribute Name The default is Name, […] |
Status Update 2 May 2019 - It's been a few days, but I've been out of town and no time to review changes. Quite a few items worked through this week and some nice changes. Code scrolling for wide lines (yay!) Forum rewriting of some links/titles is fixed to allow links to specific posts Remembering your notification settings works with replying […] |
Fixate the Menu bar - Is it possible to make Menu bar and Search bar to be always visible and not scroll with the page? |
SSIS: Ignore corrupted files when importing flat files - Hello, I created a package that imports csv files into a foreach from a defined directory to a sql server table. It is possible that in this directory there are some corrupt files that is to say they do not have the right number of columns waited by the source component of the flat file. […] |
TSQL: How to transform first row as column name? - Hello, I hope you are all well. I would like your help on a data transformation task that I have. I would like to convert the first row of a table to a column name I am working on SQL Server Azure and I get daily data from another service.This service loads a table that […] |
Date time time zone conversion built in function - I have legacy databases that stores all data in U.S. Central Standard Time. Some servers are on CST and others are on UTC. Built-in function getdate() gets date in the server time, while getutcdate() gets date in UTC. I need a function that will always return date in CST irrespective of the server time. I […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |