Viewing 15 posts - 2,236 through 2,250 (of 2,356 total)
bryan van ritter (9/17/2013)
i am trying to convert a nvarchar column to a decimal value.
the nvarchar column has empty records as well as NULL values.
now when i try...
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/
September 17, 2013 at 11:41 am
Microsoft's move in this area does not surprise me.
Simply put, they were not making money on this program. They probably are making lots of money on the...
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/
September 5, 2013 at 3:31 pm
I can tackle this. I have a good one in place in all of my databases. The script has been passed around the block many times.
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/
September 4, 2013 at 11:54 am
Gee, this sure sound like using BCP in character based mode would do the trick.
BCP DatabaseName.schema.table OUT FileName.csv /m 100 /b 100 /e TableName.err /c /t\, /r /S ServerName /T...
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/
August 15, 2013 at 10:35 am
This appears to be a significant design flaw.
The first question is would address be considered an entity, or is address really an attribute of Other entities? :Salesman has address"...
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/
August 15, 2013 at 9:45 am
Good job on the article, BUT.
If you think that this is a solution, and are planning on relying on this as some sort of protection from stupid, it's not. There...
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/
August 9, 2013 at 3:57 am
Why is shorter better?????
This is the fight I have had with developers for years. They provide the argument that "ThisIsTheProductionDatabase" is too much typing, so they name 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/
August 1, 2013 at 9:56 am
I have used SQL Recon with great success.
http://www.specialopssecurity.com/labs/sqlrecon/
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/
July 16, 2013 at 1:08 pm
This may be a bit of a DUHHHHH, but who owns these jobs???
I seem to remember, a long time ago, in a galaxy far away, the same issue when the...
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/
June 20, 2013 at 1:45 pm
webbies (5/17/2013)
I have a database that contains 2 tables (sql server 2008):
LenderCommission
ID int
Commission decimal
CommissionTier
ID int
MinCommission decimal
MaxCommission decimal
I want to create a relationship between the 2 tables. The obvious way would...
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 17, 2013 at 7:07 am
Not sure what you mean here. All of the numbers are decimals.
Are you looking for the values that are a whole number?
1.0, but not 1.1???
This may work
SELECT *...
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 17, 2013 at 6:58 am
That's your answer. Account_id is the primary key. It is already unique. The use of distinct will produce the same number of rows as the query without...
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 26, 2013 at 3:21 am
tushaar.kudalkar (7/27/2009)
HiU need to stop the server services or else u will not be able to move ur .mdf and .ldf files
This is not true. The only time you...
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, 2013 at 11:37 am
Lynn Pettis (4/9/2013)
This help?
SELECT
DATEPART(WEEK, DATEADD(MONTH, +3, getdate())),
dateadd(week,datediff(week,0,getdate()),5),
DATEADD(MONTH, +3, dateadd(week,datediff(week,0,getdate()),5));
The calander table is about as elegant as it gets....
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 9, 2013 at 2:28 pm
You could do some ugly manipulation to create the date.
Or, you could create a calendar table and simply query it.
This is one article on nthis site; there are others....
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 9, 2013 at 1:38 pm
Viewing 15 posts - 2,236 through 2,250 (of 2,356 total)