Viewing 15 posts - 3,796 through 3,810 (of 6,035 total)
Membership in SYSADMIN on the 2008 server is not necessarily required. Having the DBA on the 2008 server grant your remote login "VIEW ANY DATABASE" permission will allow you to...
June 3, 2015 at 3:33 pm
If it were me, and we're talking about a local developer instance, then I'd just uninstall SQL Server 2012, and then re-install SQL Server 2014. It will support all the...
June 3, 2015 at 3:25 pm
Your first priority should be to learn whatever tasks will help make you more useful in your current job, which you said is monitoring servers, and then expand outward. I'm...
June 3, 2015 at 10:17 am
yusufm 48726 (6/3/2015)
Sure I have attached it. This one looks ok but sometimes it gives me wrong value in between.
I was assuming that your DateEntered column contained MMDD coded as...
June 3, 2015 at 9:36 am
J Livingston SQL (6/3/2015)
what does Order By Value DESC give you?
LOL! Havn't had this morning's coffee yet? 😉
June 3, 2015 at 9:05 am
Are these the actual values in the 'DateEntered' column you're attempting to order by?
1022
987
876
870
950
690
580
These arn't date values, they are integers. So, I'm assuming that Jan 1 would be coded as...
June 3, 2015 at 9:04 am
Dave62 (6/3/2015)
Company X has offered me $yyyyy. Will you match it?
... "No one wants to be put in a corner, and I would be likely to let you move on...
June 3, 2015 at 7:59 am
Of course, you could always use EF and LINQ to code once and "level the playing field" for the various RDBMS platforms.
:rolleyes:
June 2, 2015 at 2:17 pm
It's good to remind folks that privillages, even for more advanced things like operating backups or running performance tuning queries, can be granted piecemeal without adding the login to SYSADMIN...
June 2, 2015 at 8:02 am
When starting working on a modification to a stored procedure, I start by comparing what's in production to the latest in the production branch of the source code repository. They...
June 2, 2015 at 7:49 am
So we're talking v2016 now; it's hard for me to believe that our DW is three releases behind already. SQL Server v2008 may end up being the most extant version...
June 2, 2015 at 7:31 am
TomThomson (6/1/2015)
GoofyGuy (6/1/2015)
That happy situation probably applies only to database developers in companies who are developing databases for in-house use only.
Indeed, as Mr Russell explained to me already (twice).
😉
Well,...
June 2, 2015 at 7:24 am
I can't entirely digest all what you've said above. But taking a step back, here is what I'd propose:
Have the raw daily transactions from the CRM imported into an Excel...
June 1, 2015 at 12:10 pm
SQL doesn't provide for conditionally returning columns. However, you can have a computed column that contains values from multiple columns appended together. For example, you can return your events as...
June 1, 2015 at 11:50 am
fliteskates (5/29/2015)
I am trying to learn how to use SQL and I have downloaded MSSQL Server 2014 Express. I am a complete beginner with little experience.
I just downloaded and...
June 1, 2015 at 10:47 am
Viewing 15 posts - 3,796 through 3,810 (of 6,035 total)