Forum Replies Created
Viewing 15 posts - 3,181 through 3,195 (of 59,067 total)
-
Reply To: How to Replace LF to CRLF in file source connection
I know little about SSIS but I'm sure there's a setting for the line terminators.
-
Reply To: Pizza Math
As a bit of fun, I ran across this picture on LinkedIn about a week ago. I laughed so hard it hurt. 😀
-
Reply To: SQL replace with escape characters
snomadj wrote:Great, thanks! That does the trick perfectly.
Be careful... it only works for a single instance on any one row. If there are two instances, it only takes care of...
-
Reply To: Error converting data type varchar to bigint.
I don't know... I don't work with anything having to do with Azure.
-
Reply To: Quick SQL challenges for mid-experienced+ DBAs (and advanced T-SQLers)
planetmatt wrote:For 1, I tried a CTE to create a Month lookup table. No hardcoded string values
;WITH CTE_Months
AS
(
SELECT GETDATE() AS TheDate, LEFT(DATENAME(mm,GETDATE()),3) AS [MonthAbr],MONTH(GETDATE()) AS MonthOrder
UNION ALL
SELECT... -
Reply To: IQ Vs Stratascratch
micchon wrote:Passed the initial screening and now have a SQL interview. Dabbled with SQL for a few months now but there are a lot of resources that I can use...
-
Reply To: First responders kit - BlitzIndex question
ScottPletcher wrote:If "silly" people are writing such queries -- and no one in IT can tell you to ignore them ...
My problem is that those two groups are frequently the...
-
Reply To: Performance problem
How fix SQL performance issues? Start by checking your wait stats
1-Ensure your TempDB database is configured optimally.
2-Make sure you're running index maintenance frequently.
3-Implement indexes that provide a benefit to...
-
Reply To: Quick SQL challenges for mid-experienced+ DBAs (and advanced T-SQLers)
Steve Collins wrote:select cast(year(v.sort_mo) as smallint), input_str.mo
from (values ('Jan'),('Feb'),('Mar'),
('Apr'),('May'),('Jun'),
... -
Reply To: Quick SQL challenges for mid-experienced+ DBAs (and advanced T-SQLers)
There's something crazy going on with Jonathan's machine, Scott. Look at the results of your code in his run... it's all over the place.
I'll also say that on both my...
-
Reply To: Quick SQL challenges for mid-experienced+ DBAs (and advanced T-SQLers)
Oh my! That's a crazy amount of difference, Jonathan... even from the runs for the same code. What else is running on your machine?
I'm running SQL Server 2017 Developer's Edition
The...
-
Reply To: Quick SQL challenges for mid-experienced+ DBAs (and advanced T-SQLers)
For Question #1, Scott's method is the fastest. Don't take my word for it, though. Here's the test table...
--===== If the test table exists, drop it just...
-
Reply To: Quick SQL challenges for mid-experienced+ DBAs (and advanced T-SQLers)
Steve Collins wrote:Here's 1, 3, and 4
--(1)
select v.sort_mo, input_str.mo
from (values ('Jan'),('Feb'),('Mar')) input_str(mo)
cross apply (values (parse(concat(input_str.mo, '-01-1900') as date))) v(sort_mo)
order by v.sort_mo;I was going...
Viewing 15 posts - 3,181 through 3,195 (of 59,067 total)