Viewing 15 posts - 16 through 30 (of 496 total)
July 12, 2018 at 11:21 pm
TheSQLGuru (5/30/2016)
May 31, 2016 at 12:00 am
Sergiy (5/3/2016)
Are you sure the XML's stored in the table contain line breaks?
Not sure, but I need a way to somehow transform it, so it has line breaks. Management...
May 3, 2016 at 11:55 pm
Jeff Moden (2/14/2016)
Roust_m (2/13/2016)
I have four SQL instances (currently Enterprise) which I want to downgrade to Standard edition.
I can have couple of days downtime for the server, so I will...
February 15, 2016 at 4:34 am
Jeff Moden (1/21/2016)
Roust_m (1/20/2016)
I am planning to un-partition and decompress some large tables to be able to use standard edition of SQL Server.
Given that not clustered indexes get rebuilt when...
January 24, 2016 at 2:41 pm
e4d4 (1/22/2016)
January 24, 2016 at 2:29 pm
Eirikur Eiriksson (1/20/2016)
Roust_m (1/20/2016)
I am planning to un-partition and decompress some large tables to be able to use standard edition of SQL Server.
Given that not clustered indexes get rebuilt when...
January 21, 2016 at 12:33 am
Grant Fritchey (8/3/2015)
Trying to do all this dynamically is going to be a bear. Can you break apart the USE statement and the ALTER statement?
Tried, but the same error happens:
select...
August 4, 2015 at 6:38 pm
Grant Fritchey (7/31/2015)
Ah, it wasn't clear in the first post this is all dynamic SQL.Try wrapping this in a transaction
exec sp_executesql @s-2
When I do this, I...
August 3, 2015 at 5:59 pm
Grant Fritchey (7/30/2015)
Try it with explicit transactions, separating the ALTER command from the others.
I have replaced:
select @s-2 = 'USE [' + @DBName + ']
IF EXISTS (select *...
July 30, 2015 at 9:16 pm
Hi,
I've done a fully dynamic scripts which take the database, the table and sometimes the partitioning column. They were a mix of TSQL and Powershell steps.
The process includes creating...
July 28, 2015 at 9:01 pm
Solved the problem: subscription needs to be created from a script versus GUI. GUI seems to have a lot of restrictions.
June 9, 2015 at 10:06 pm
7 tables partitioned by month, 41 partitions, each month is in its own file and filegroup. The name of the file and the filegroup it belongs to is the...
May 5, 2015 at 4:18 am
Luis Cazares (5/4/2015)
1. Why are you using Dynamic SQL when a normal query would be enough?
2. Why aren't you parametrizing your Dynamic SQL leaving it open to SQL Injection?
3....
May 4, 2015 at 11:35 pm
Viewing 15 posts - 16 through 30 (of 496 total)