If a column is normalized, but the user really wants to see the values as a short comma separated list, how can I write a query that produces the list? Concatenating the values in a column would be pretty easy if SQL Server had a concatenate aggregate function, which it doesn't. What's more, for efficiency sake it's important to write the reporting queries without using cursors.
Trust is a big part of any DBA's job. But it seems that many people in society trust each other less and less all the time. Steve Jones has a few comments on this important subject.
Trust is a big part of any DBA's job. But it seems that many people in society trust each other less and less all the time. Steve Jones has a few comments on this important subject.
Trust is a big part of any DBA's job. But it seems that many people in society trust each other less and less all the time. Steve Jones has a few comments on this important subject.
Phil takes us through one of the best kept secrets of SSMS - Templates. Even for a 'plain-screen' man like Phil, Templates are an excellent tool, and a major reason to use SSMS.
How can we determine the sheet names in our SSIS package and process this variable number of sheets?
New data-profiling tools native to SQL Server 2008 Integration Services such as the Data Profiling task and the Data Profiler Viewer help manage a business intelligence strategy.
Think about your career and the managers, and potentially leaders, that you’ve had in your life. Think about life in general and who do you admire, who have you modeled yourself after or who you wanted to follow in sports, in a hobby, in life, etc.
Despite the fact DBAs are essentially protectors of an organization’s knowledge, and privy to much confidential information, there is no clearly defined set of rules and standards to help govern and guide their ethical behavior. Brad McGehee thinks it's time for some action on this issue.
In this video MVP Brian Knight explains how you can use the model viewers to see how the data mining task will process your data.
By gbargsley
One of the first things I review when I inherit a new SQL Server...
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
Comments posted to this topic are about the item What Happens When You Ask...
Comments posted to this topic are about the item Detecting Characters
hi a peer of mine who ive never known to be wrong says a...
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers