Viewing 15 posts - 1,096 through 1,110 (of 5,109 total)
Are you talking from experience here, or in the event of? If the latter your developer shouldn't have access to be able to DROP a production database; they are developers...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 18, 2019 at 11:49 am
The normal (non-dynamic) way you would achieve this would be with a something called a Cross-Pivot. Like the below (note I have changed the objects to persisted objects, due to...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 18, 2019 at 11:23 am
Cross post of https://www.sqlservercentral.com/forums/topic/sql-server-agent-scheduled-job-taking-abnormally-long-time-to-run-2
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 17, 2019 at 10:18 pm
Thanks for the updates Steve. We all appreciate the ongoing work and it's nice to hear the state of play. I assume that things will slow down a little bit...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 17, 2019 at 10:04 pm
4.I still don't see mine. And I don't see the picture/icon of the person.
Do you mean this page? I got there by clicking your username in the left,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 17, 2019 at 5:45 pm
Hi Thom, The database which I am currently working is not supporting the ROW_NUMBER() OVER (PARTITION BY schema_id ORDER BY [name]) clause. so I am checking any alternatives to these...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 17, 2019 at 11:18 am
Are there any other errors as well? SSIS often produces multiple errors, especially with an error like that. An error like that is normally accompanied by another.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 17, 2019 at 11:03 am
Could you elaborate here? Why does ROW_NUMBER not serve the requirement? You could use COUNT with a ROWS BETWEEN clause, but why reinvent the wheel?
SELECT [name],
...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 17, 2019 at 11:00 am
As long as it's not Section 31 masquerading as the Obsidian Order masquerading as the Tal Shiar masquerading as the Ghost of Captain Cutler, we should be fine....
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 16, 2019 at 10:53 am
Latest Topics is latest topic, not latest replies (what I have posted here is a reply, not a topic). That actually makes sense. For the most recently active topics (aka...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 15, 2019 at 3:18 pm
solved the problem
What was the solution, out of interest?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 15, 2019 at 3:11 pm
This is the first I heard of the 'website issues' forum. I'll see if I can copy and paste it there.
It's been there for as long as I can...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 15, 2019 at 2:40 pm
Ha Ha, look at that post, you can't tell my original from Sean's to my reply to Sean's. Horrible.
Put them the bugs in the Website Issues forum, then...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 15, 2019 at 2:26 pm
I'm heartbroken here. The Corgi Completion Contest "discussion" hyperlink leads to the article on data compression (https://www.sqlservercentral.com/editorials/data-compression-double-take). <sniff><sniff>WAAAAAGGHHHH! @=(
I think something must be broken then, as I've had several...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 15, 2019 at 1:22 pm
If you really want to use COUNT instead of SUM you could do:
COuNT(CASE WHEN DateColumn >= '20190101' AND DateColumn < '20190201' THEN 1 END) AS Jan19
As there...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 14, 2019 at 4:55 pm
Viewing 15 posts - 1,096 through 1,110 (of 5,109 total)