The week that was: Friday 15th July 2010
This is just a short post for a Friday, I have no technical content ready to publish today but lots...
2010-07-16
640 reads
This is just a short post for a Friday, I have no technical content ready to publish today but lots...
2010-07-16
640 reads
This months TSQL2sday is being hosted by Robert Davies of MCM and Microsoft fame, you can find his post here....
2010-07-13
795 reads
Have you ever had a scheduled run of one of your SSIS packages fail? Have you ever wished you had...
2010-07-12
2,034 reads
I was setting up some SQL Server agent jobs in a test environment. I needed one of our testers to...
2010-07-09
14,304 reads
I have been procrastinating this evening, I have several blog posts that I want to write but the football is...
2010-07-08
586 reads
OK for my next DB2 trick and remaining off the path of the righteous for the time being we will...
2010-06-30
4,966 reads
2010-06-28
668 reads
It is generally recommended that 'lock pages in memory' be enabled for your SQL Servers to prevent the OS paging...
2010-06-25
9,624 reads
On the 19th/20th May (last month) the Professional Association of SQL Server (PASS) held its second 24 hours of PASS...
2010-06-23
720 reads
Recently I was installing Windows Server 2008 R2 Enterprise Edition onto a virtual machine (VM) I was setting up to...
2010-06-22
2,301 reads
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Hi we run 2019 ssas std. Yesterday i imported my tabular project to vs...
Code for mssql 2008 DECLARE @CompanyID TINYINT DECLARE @MemNo decimal DECLARE @MemberFrom Integer DECLARE...
I have an execute task(has server list from a table) pointing to foraeachloop foreachloop...
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex] FILE = N'thirdone' , FILE = N'thirdtwo' , FILEGROUP = N'second' TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak' WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GOSee possible answers