No announcements
Found 3447803 threads
-
0 Votes
Best practice on database versioning
My plan to do this is to interrogate the CRUD requests in the Mobile Services server-side script to see if they are coming from a supported version of the app.Answered | 3 Replies | 1683 Views | Created by Tim SF - Saturday, November 16, 2013 9:08 PM | Last reply by Tim SF - Monday, November 18, 2013 1:46 PM -
7 Votes
Best Practice for Distributing Databases to Customers
Its much easier to distribute schema/data from an older version to a newer one than the other way around.Answered | 8 Replies | 957 Views | Created by Anonymous76876853w - Friday, October 10, 2014 2:09 PM | Last reply by Saeid Hasani - Wednesday, October 15, 2014 8:15 PM -
0 Votes
Best Practice for adding data files?
Follow these 10 points in the link http://technet.microsoft.com/en-us/library/cc966534.aspx , you will get answers for many of your questions.Answered | 2 Replies | 5156 Views | Created by dbeers - Friday, September 18, 2009 6:22 PM | Last reply by dbeers - Friday, September 18, 2009 8:03 PM -
0 Votes
Database Connection Best Practices
Alan Chen[MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from ...Answered | 5 Replies | 8588 Views | Created by Bryan Valencia - Tuesday, August 2, 2011 9:25 PM | Last reply by Bryan Valencia - Tuesday, August 23, 2011 2:26 AM -
3 Votes
Best Practices for Data Access
In practice, a better option is to create an SQL login that is member of sysadmin - or who have rights to impersonate an account that is member of sysadmin.Answered | 10 Replies | 1510 Views | Created by Zach Attack - Tuesday, May 20, 2014 4:37 PM | Last reply by Zach Attack - Monday, June 2, 2014 8:06 PM -
0 Votes
Best Practice for Database and Transaction settings
My original question was "is there a Best Practice document on how to create a database and manage transactions within an ...Answered | 7 Replies | 6512 Views | Created by JamesMoorhouse - Friday, February 25, 2011 12:44 AM | Last reply by Alan_chen - Tuesday, March 8, 2011 1:04 AM -
1 Votes
Best practice for customer data on Azure
so instead of SELECT firstname FROM Employee WHERE employeeID=33 I would add to that, SELECT firstname FROM Employee WHERE employeeID=33 and ownerID=28, because for ...Answered | 8 Replies | 6717 Views | Created by thp1111 - Thursday, August 25, 2011 12:02 AM | Last reply by thp1111 - Thursday, August 25, 2011 10:58 PM -
0 Votes
Best practices: getting statistical data from multiple queries for Overview dashboard
Looks like your best friend here is Power BI..Answered | 6 Replies | 726 Views | Created by Pettt - Wednesday, October 31, 2018 8:00 AM | Last reply by Uri Dimant - Wednesday, October 31, 2018 10:39 AM -
0 Votes
Best practice PDW database backup strategy/plan
Hi Anish.S, According to your description, you want to backup SQL Server Parallel Data Warehouse (PDW) database.Answered | 3 Replies | 2293 Views | Created by Anish_20 - Sunday, April 5, 2015 4:33 PM | Last reply by Anish_20 - Thursday, April 16, 2015 8:02 PM -
2 Votes
Best Practice for Designing Database Tables?
This is when real issue start, they are calling their data from our server through internet while having 2000 unit sending data to our server, they keep on ...Answered | 6 Replies | 1325 Views | Created by Omar Bizreh - Friday, August 15, 2014 11:26 AM | Last reply by Omar Bizreh - Friday, August 15, 2014 6:16 PM -
1 Votes
database file size best practice
I vaguely recall some discussions about keeping filesize below some number like that as a best practice for some obscure NTFS reasons, or something, which might ...Answered | 4 Replies | 8264 Views | Created by Skiiiiii - Monday, July 23, 2012 5:47 PM | Last reply by JRStern - Tuesday, July 24, 2012 9:31 PM -
4 Votes
Database Normalization best practices help
Aren’t you better off designing a database for growth in mind rather than ignoring the impact of duplicate data and table growth?Answered | 10 Replies | 12885 Views | Created by a100011 - Friday, September 10, 2010 9:25 PM | Last reply by Louis Davidson - Thursday, January 17, 2013 10:11 PM -
7 Votes
Best practice adressbook database
But if you do it right, that is the best way.Answered | 5 Replies | 3879 Views | Created by SpaceLama - Tuesday, July 17, 2012 8:46 AM | Last reply by SpaceLama - Tuesday, July 17, 2012 4:14 PM -
0 Votes
System Databases Maintenance Plans Best Practice
Configuring these plans for system dbs are also essential (dbcc checkdb) and apart from that i would say it depends on your environment to decide the frequency ...Answered | 2 Replies | 7776 Views | Created by SQLRocker - Tuesday, November 10, 2009 8:36 PM | Last reply by SQLRocker - Tuesday, November 10, 2009 9:38 PM -
0 Votes
best practices to store Landset Data in SQL Server?
what is the best practices to store Landset Data in SQL Server?Answered | 3 Replies | 925 Views | Created by manishcal16PPS - Tuesday, July 14, 2015 6:54 AM | Last reply by manishcal16PPS - Tuesday, August 4, 2015 8:53 AM -
5 Votes
Best Practices for Development Environment Data setup
We use etl's to load the data from our ERP system to the Staging DB then to get the data to the ODS and DW we use stored ...Answered | 5 Replies | 1194 Views | Created by khan0809 - Wednesday, September 23, 2015 7:26 PM | Last reply by khan0809 - Wednesday, September 30, 2015 9:05 PM -
0 Votes
Database Project Setup Best Practices
Developers working on each application can then work on the database project in isolation from other developers working on different applications.Answered | 3 Replies | 5732 Views | Created by CDD121 - Wednesday, October 14, 2009 5:27 PM | Last reply by antxxxx - Thursday, October 15, 2009 9:02 AM -
0 Votes
best practices
and don't get scary, it's really eazy to get it, much easier and more convenient than DSs hope this was helpful ShimmyAnswered | 1 Replies | 2871 Views | Created by Dagz - Sunday, September 7, 2008 4:08 PM | Last reply by Shimmy Weitzhandler - Monday, September 8, 2008 7:50 AM -
0 Votes
Best practices for SCCM SQL database migration.
It is about moving the database from one SQL Server to another...Answered | 4 Replies | 2401 Views | Created by kimdav111 - Thursday, February 4, 2016 9:29 PM | Last reply by Venkat Padavala - Tuesday, July 4, 2017 11:29 AM -
0 Votes
Best Practice for design for database
There is a duplicate row in your sample data ('RT', '1111').Answered | 4 Replies | 4302 Views | Created by Brandong - Monday, January 30, 2012 5:15 AM | Last reply by Brandong - Monday, January 30, 2012 2:55 PM - Items 1 to 20 of 3447803 Next ›
No announcements