Viewing 15 posts - 3,796 through 3,810 (of 6,038 total)
The solution to this problem depends on why (or if) the rowset displayed to users really needs to contain a list of sequential numbers. Attempting to maintain the sequential integrity...
June 4, 2015 at 7:53 am
For a handful of reasons, besides performance, it's best not to return all columns from a table using * but rather to specify only the minimum columns your application or...
June 4, 2015 at 7:14 am
Shelley Allen (6/3/2015)
I fixed this. When creating a linked server in 2012 to another SQLSERVER you need to click 'SQL Server' under Server Type on the General TabShelley
So when...
June 4, 2015 at 7:09 am
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
Viewing 15 posts - 3,796 through 3,810 (of 6,038 total)