How do I effectively find out if the Tempdb database is suffering from an allocation bottleneck? Should I create multiple TempDB files per core on this server to improve performance? How do I check this information programmatically?
2009-10-13
4,199 reads
With SQL Server 2008, you will have new built-in support for location based data types and supporting geospatial features. Next you will learn how these new data types work.
2009-10-13
2,899 reads
By now, hopefully everyone has heard of the security breach where accounts and passwords were found on a public site listed the account usernames and passwords of some 10,000 users. Initially it was just reported to be Hotmail/Live.com/MSN, but it turns
2009-10-13
3,534 reads
Would you want to work at Microsoft? Do you think Steve Jones does? Read a few thoughts from him on his experience with the software giant.
2009-10-13
118 reads
Would you want to work at Microsoft? Do you think Steve Jones does? Read a few thoughts from him on his experience with the software giant.
2009-10-13
109 reads
Would you want to work at Microsoft? Do you think Steve Jones does? Read a few thoughts from him on his experience with the software giant.
2009-10-13
83 reads
We have expanded our forums with a new Question and Answer site based on the StackOverflow codebase. Please feel free to visit.
2009-10-12 (first published: 2009-10-09)
863 reads
Satish More brings us a framework that you can use to execute a number of jobs in parallel and finish a task quickly.
2009-10-12
11,954 reads
Discover how to call stored procedures and functions in MySQL from PHP using three database extensions: MySQL, MySQLi, and PDO.
2009-10-12
1,576 reads
SQL Server Management Studio provides a wizard to generate script out of a database. Learn how to automate the process to generate and store the database script.
2009-10-12
3,712 reads
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
hi, in an ssis for each loop over an object variable called MyListVariable, i...
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers