When someone asks you what you do for work, how do you answer?
In many ways job titles matter, just not when telling a stranger what you do for work.
2018-07-30
180 reads
Search results for "title"
Your search for "title" returned 100 results:
2021-02-16
5,141 reads
Error with SSIS and Excel
I am trying to use the Excel Connection Manager in SSIS 2008 R2. I have set Run64BitRuntime = false. I have tried to process several .xls files that have one worksheet. But I get an "unexpected error from external database driver (22)" message from them. When I use the original worksheet tab name (for example, […]
2011-04-18
3,785 reads
Nested Iif expression...
I'm trying to figure out the syntax on an RS expression, but keep getting compile error msgs. Example below: If Title value = "Director" OR Title value = "Mgr" AND IF SupervisorName value = "Jane Smith" THEN "Las Vegas" ELSE IF SupervisorName value = "John Doe" THEN "Ft. Laud" ELSE SupervisorName Value ELSE IF Title […]
2008-08-25
126 reads
SQL Full Text search Column weighting
Hi,I wonder if anyone can help me on this one.I'm just getting to grips with 2005 and trying out the Full Text searching.Is there any way that i can weight columns NOT search terms but columns in the index. ie if i searched for "Harry Potter" and it appeared in a title field instead of […]
2006-02-07
455 reads
SSRS cascading parameter doesn't change value when upstream parameters change
My report has a title that is based on the values in a couple of parameters. I'd like to add a feature to the report where the user can overtype the value for that title when the logic that sets it doesn't give quite the result they'd like. I tried adding a parameter for that […]
2021-07-21
1,786 reads
Chart!! How can I set y-axis title to top of y-axis label??
y-axis title always show on left of y-axis label . How can I set y-axis title to top of y-axis label??
2011-08-23
207 reads
URGENT Proper Case (AKA Title or Sentence Case) Function
We have UPPER() and LOWER() but SQL Svr 2k does not have a function to put strings into their proper case. i.e. Bob vs bob or BOB, O'Mally vs o'mally or O'MALLY or O'mally, etc. Does anyone have a good (read fast) function to do this?URGENT
2004-05-05
659 reads
Database Mirroring Error.
Hi, I am trying to configure database mirroring in sql server -2014 on the local windows 8 machine. I go following error . How to solve. Not: I have not configured any virtual lab.all sql server instances are on the same machine. TITLE: Database Properties ------------------------------ An error occurred while starting mirroring. ------------------------------ ADDITIONAL INFORMATION: […]
2014-10-31
361 reads
Database Mirroring setup issue
Hi, I'm trying to set up database mirroring using the database mirroring wizard in SQL Server 2008 R2 RTM x64 developer edition on Windows Server 2008 R2 EE x64 SP. Primary Server: SRV1 Instance:SRV1/ins1 Mirror Server:SRV2 Instance:SRV2\ins1 I have selected all default configuration in the wizard to set up mirroring for AdventureWorks database . But […]
2011-07-11
3,083 reads
Blogs
Query deadlock info in Azure SQL DB
A couple of weeks ago, a developer came to me and wanted to know...
MSSQL Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database
By SQLPals
Database Property LastGoodCheckDbTime to Get the Last Successful DBCC CHECKDB on a Database As one...
Dynamic Warehouse & Lakehouse Connections in Microsoft Fabric Data Pipelines
When you develop data pipelines in Microsoft Fabric (the Azure Data Factory equivalent in...
Forums
Baseball Everywhere
Comments posted to this topic are about the item Baseball Everywhere
How to run custom python module on SQL Server?
I am working on a small test script on SQL server 2022 using python...
Upgrade to SQL2019 from 2012 Query is taking time, Need Query Optimization steps
Upgrade to SQL2019 from 2012 Query is taking time, Need Query Optimization steps and...
Question of the Day
Sensitivity Ranks
I want to use the ADD SENSITIVITY CLASSIFICATION DDL to mark some columns in my SQL Server 2022 database as PII. Can I use this code?
ADD SENSITIVITY CLASSIFICATION TO dbo.sales.price,
dbo.sales.discount
WITH (
LABEL = 'Highly Confidential',
INFORMATION_TYPE = 'Financial',
RANK = 'INTERNAL ONLY'
); See possible answers