Partitioned Table and Index Strategies Using SQL Server 2008
The Microsoft SQL Server 2008 database software provides table partitioning to make such operations more manageable.
The Microsoft SQL Server 2008 database software provides table partitioning to make such operations more manageable.
We all try to help others with advice, but sometimes we end up doing damage. Steve Jones asks for the worst advice you see given in this Friday poll.
We all try to help others with advice, but sometimes we end up doing damage. Steve Jones asks for the worst advice you see given in this Friday poll.
We all try to help others with advice, but sometimes we end up doing damage. Steve Jones asks for the worst advice you see given in this Friday poll.
Part 2 of MVP Andy Warren's SQL School video on Instead of Triggers.
Would you disclose the password for your online sites to get a job? That was required of applicants in Bozeman, MT until recently. Steve Jones is stunned by this.
Implement a CRUD automation framework that handles insert and simple queries, an easy way to talk to a database without needing to write any database-access code.
Have you ever noticed unexpected gaps in sequences in IDENTITY columns? Even though you’ve got transactions set up for your inserts and a no-deletion policy, you find that there are missing values in what should be an unbroken sequence of numbers. The problem could be partially related to transaction rollbacks.
Would you disclose the password for your online sites to get a job? That was required of applicants in Bozeman, MT until recently. Steve Jones is stunned by this.
The honeymoon is over, and macOS 26 Tahoe broke the Rosetta 2 emulation layer...
By Chris Yates
There are moments in technology when the ground shifts beneath our feet. Moments when...
Why Developers Shouldn’t Have sysadmin access in SQL Server 7 reasons—and exactly what to do instead It...
Import-Module ImportExcel # Path to your .sql file $sqlFile = "C:\Data\MyQueries.sql" $excelPath = "C:\Data\SqlExtract_$(Get-Date...
I have noticed sp_executesql also makes a single plan for a stmt with parameter...
If I want to track which login called a stored procedure and use the value in an audit, what function can I use to replace the xxx below?
create procedure AddNewCustomer @customername varchar(200) AS BEGIN DECLARE @added VARCHAR(100) SELECT @added = xxx IF @customername IS NOT NULL INSERT dbo.Customer ( CustomerName, AddedBy ) VALUES (@customername, @added) ENDSee possible answers