Viewing 15 posts - 1,261 through 1,275 (of 2,732 total)
Presuming by "short date" you mean yyyy-mm-dd format, you could do this:
CONVERT(date, getdate())
You could also further tune that with the various date style options.
But, it's possible if this is in...
November 16, 2016 at 1:19 pm
Another book I'd suggest would be "Troubleshooting SQL Server: A Guide for the Accidental DBA"
You can get the PDF for free from Red Gate (disclaimer: I don't work for Red...
November 16, 2016 at 10:08 am
GilaMonster (11/16/2016)
jasona.work (11/16/2016)
My response to that was two words, one of which I shouldn't use in polite company and the first was "holy":w00t:
I was screaming at my monitor last night.
I...
November 16, 2016 at 9:18 am
Grant Fritchey (11/16/2016)
SP1 for 2016 (which also has CREATE OR ALTER).
A single development surface. This means all functionality in Enterprise is also in Standard and Web (WHOOOP!).
vNext community preview...
November 16, 2016 at 8:57 am
GilaMonster (11/16/2016)
Ed Wagner (11/16/2016)
Care to drop any hints?
No. Not until the announcements are made.
Check Twitter later (Grant, Tom LaRock, Kendra, etc) they should be tweeting the highlights (I'm trying...
November 16, 2016 at 8:38 am
Gail Wanabee (11/15/2016)
3) Cannot open backup device "\\serverName\TestLogShipping\TestLogShipping.bak"4) Operating system error 5(Access is denied.).
Those two lines right there indicate a permissions problem.
As Kevin indicated, make sure the SQL Agent service...
November 15, 2016 at 12:54 pm
Grant Fritchey (11/15/2016)
VARCHAR(1) is my favorite data type of all time... Well, behind VARIANT, but hopefully that's going to be on the ash heap soon.
If I recall, though, to give...
November 15, 2016 at 7:57 am
Cool!
Hmm, now to plan a Mexican vacation with the wife...
😀
November 15, 2016 at 7:55 am
So I get asked about index maintenance and in looking at the table in question for the dev, I notice something...
Something...
Off...
A bunch of columns defined as "VARCHAR(1), NULL"
:rolleyes::ermm:
It's not all...
November 15, 2016 at 7:27 am
Brandie Tarvin (11/10/2016)
jasona.work (11/10/2016)
Capt'n!The Bird o' Prey is gone!
They must've cloaked!
First thing I thought of when I saw this:
MSI (c) (28:2C) [14:35:09:178]: Cloaking enabled.
You are a bad, bad boy!
Hey!
I'm...
November 10, 2016 at 12:23 pm
Capt'n!
The Bird o' Prey is gone!
They must've cloaked!
First thing I thought of when I saw this:
MSI (c) (28:2C) [14:35:09:178]: Cloaking enabled.
November 10, 2016 at 11:21 am
GilaMonster (11/10/2016)
sql 2005 to oracle11g database upgrade please send the step by step process
Um, ok...
Come now, the steps to do this are quite simple, really, anybody could do it.
0....
November 10, 2016 at 8:03 am
Mindy Hreczuck (11/3/2016)
November 3, 2016 at 12:41 pm
Great, glad you resolved the problem!
Isn't it wonderful when it ends up being a really easy fix?
November 3, 2016 at 10:51 am
You know, I think you guys might be right, especially considering they wouldn't be at home, so most people will be in their own homes watching the games.
Might get a...
November 2, 2016 at 11:53 am
Viewing 15 posts - 1,261 through 1,275 (of 2,732 total)