Working as a server is not for the faint of heart. From managing unruly customers to handling multiple tables at once, waitstaff often find themselves walking a fine line between excellent service and ...

SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer need ...

Knowing exactly what in-memory OLTP tables are used for will help you make the most of one of SQL Server's newest features. While in-memory online transaction processing (OLTP) tables may sound like a ...

I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...

I was just wondering if anyone was dumping performance monitoring data to SQL Server tables?<BR><BR>Any tips, advice, thoughts in general on this?<BR><BR><BR>Lessons hard learned, ...

What are the advantages of using Access as the front end to a SQL Server database? For starters, it’s likely that your client’s users will be more familiar with it, and it’s relatively easy to put in ...