Forum Replies Created
Viewing 15 posts - 5,566 through 5,580 (of 59,068 total)
-
Reply To: Performance Issues
Yes. Something is temporarily blocking all those processes and you need to find out what that is.
-
Reply To: Please help to get duration between two 4 or 3 character string
The following will work whether the source data is an INT or VARCHAR(). Of course, it has the same caveat that Phil mentioned.
SELECT end_time/100*60 + end_time%100...
-
Reply To: Remote Registry service and Get-DbaProductKey
My recommendation would be to contact the people that wrote the "Get-DbaProductKey" PoSh snippet and ask them.
-
Reply To: How to write query generate unique Id for concate both columns search parts and
ahmed_elbarbary.2010 wrote:I work on sql server 2012 . I face issue I can't generate unique Id from merge or concave both columns
Search Parts and Company ID and generated Id must...
-
Reply To: Please help to get duration between two 4 or 3 character string
DBA.k wrote:
DATEDIFF(minute, CONVERT(varchar,[begin_time],8) , CONVERT(varchar,[end_time],8)) as [duration]
this was not worked for me could you please help above 3 formats how to get duration
What are the original datatypes...
-
Reply To: Getting Total Spending/Purchase of Unique Customers against Each Store - TSQL
This seems like homework. Can you post what you've tried, please?
-
Reply To: Use a VIEW for all SELECTs on every TABLE for futureproofing?
Kristen-173977 wrote:Perhaps instead of my proposed solution I should ask the good folk here how do you handle refactoring a table?
My answer is, of course, "It Depends" on what the...
-
Reply To: opening a database
Just a bit of advice... I know your intentions are honorable but there's no way I'd ever download a copy of a company database to a personal machine, if that's...
-
Reply To: How to contact a Moderator?
Sending the same message to the WebMaster does the trick, Kristen. I've made the same mistake in the past and, especially because you're able to identify the post, they can...
-
Reply To: Use a VIEW for all SELECTs on every TABLE for futureproofing?
Jeffrey Williams wrote:If you reread what I wrote, you would see that I don't agree with creating a view for future proofing.
I stated that using a view for refactoring is acceptable...
-
Reply To: Use a VIEW for all SELECTs on every TABLE for futureproofing?
There are a whole lot of things that SHOULDN'T be done to a table. The fact the matter is, they DO happen in real life, Jeffrey, and you have to...
-
Reply To: Lookup Match n No Match
yrstruly wrote:I would like to compare two files, that should give me. a Match and No Match output in separite tables. Can somebody send ma screenshot/link of such a ssis...
Viewing 15 posts - 5,566 through 5,580 (of 59,068 total)