Viewing 15 posts - 2,071 through 2,085 (of 2,356 total)
+ 100.
I did not have enough caffeine today! As soon as I saw your post I hit myself on the head!
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 15, 2015 at 8:35 am
Will something like this get you started?
SELECT TN.MSDATE, CASE WHEN TN.MSDATE > T.StartDate AND TN.MSDATE < T.EndDate THEN DATEPART(yyyy, T.EndDate) END
FROM Tablename TN
INNER JOIN
(SELECT '06/30/' + CONVERT(varchar(4), DATEPART(yyyy,...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 15, 2015 at 8:17 am
On each of our servers, we have created a 'DBAUtilities" database.
This contains everything for maintenance, monitoring, capturing metrics and so forth.
This is a far better place to...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
April 27, 2015 at 9:42 am
Sarah Wagner (4/22/2015)
I doubt it 🙂
Either that, or she's not admitting it!
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
April 22, 2015 at 9:58 am
We have also been fighting this issue.
We notice it more when clicking from one "folder" to another. Such as procs to tables, databases to management, server to another server.
Some...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
April 20, 2015 at 1:55 pm
RonKyle (4/20/2015)
"Best Practices" is so overused
This is a response I've seen from designers who don't think primary and foreign keys are important. And that's just the start. And...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
April 20, 2015 at 1:39 pm
RonKyle (4/20/2015)
The function of a relational database is to enforce the business rules
No, it's not. The function of the database is to store information in a manner from which...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
April 20, 2015 at 1:37 pm
This does not work:
IF @dbname <> NULL
It needs to be
IF @dbname IS NOT NULL
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
April 20, 2015 at 1:03 pm
IceDread (4/20/2015)
Jeff Moden (4/20/2015)
Yet Another DBA (4/20/2015)
Jeff Moden (4/18/2015)
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
April 20, 2015 at 12:55 pm
run_duration is not in milliseconds.
This value 20457 translates to 02:04:57.
The code below should get you started.
isnull(CASE len(run_duration)
...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
April 20, 2015 at 10:51 am
I'm merely stating a fact that in small and medium size companies, people don't tend to use DBA's. They use dev that double as "accidental dba's". Now if you make...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
April 10, 2015 at 9:19 am
Kyrilluk (4/10/2015)
First of all, why does it suggest that only dev should come up with data to...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
April 10, 2015 at 7:47 am
I don't have time to re-write this, but...
1. The 6 selects to load the variables can be one select using case statements
SELECT
@modulo = COUNT(*) %...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
April 7, 2015 at 10:43 am
What have you tried? Can you show us what you may have attempted?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 25, 2015 at 10:35 am
Andrew..Peterson (3/24/2015)
I'm starting to think we all have a bit too much time on our hands. Now if I could just find The Rat Patrol.
That was a great show from...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 25, 2015 at 8:25 am
Viewing 15 posts - 2,071 through 2,085 (of 2,356 total)