Viewing 15 posts - 3,796 through 3,810 (of 6,041 total)
mwilliams4nc (6/4/2015)
This concerns me:...
so we are adding 2500+ vins every day and they are definitely all over the map in sequencing
Would VinID / OrderID be better?
If VinID and OrderID are...
June 4, 2015 at 1:57 pm
I'll toss this out here as a starter and welcome any feedback from peers.
First, don't prefix your table names with 'tbl'. Personally, I do prefix views with 'v' and functions...
June 4, 2015 at 1:28 pm
Can you PING the server name?
Also, can you connect using the server's IP address instead of the server name?
June 4, 2015 at 8:02 am
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
Viewing 15 posts - 3,796 through 3,810 (of 6,041 total)