Viewing 15 posts - 1,426 through 1,440 (of 5,393 total)
Any reasons why you shouldn't let SQL Server do that for you?
If you have Enterprise Edition, you can rebuild the clustered index ONLINE on the partition scheme.
Watch your tempdb/user db...
-- Gianluca Sartori
September 17, 2012 at 3:46 pm
You can also query that data from the "ms_description" extended property.
-- Gianluca Sartori
September 17, 2012 at 3:41 pm
SQL Kiwi (9/14/2012)
Gianluca Sartori (9/14/2012)
I never thought it could be that hard!
I know exactly...
-- Gianluca Sartori
September 14, 2012 at 5:01 pm
On a totally unrelated note, I'm preparing my slide deck for my first session as a speaker.
I never thought it could be that hard!
I know exactly what I want to...
-- Gianluca Sartori
September 14, 2012 at 4:37 pm
SQL Kiwi (9/14/2012)
Good grief, we have all been wrong about things from time to time.
Speak for yourself! 😛
-- Gianluca Sartori
September 14, 2012 at 4:30 pm
HAve you tried printing the @sql variable before executing?
That would give a hint. Maybe the @sql variable holds NULL or something similar happened.
-- Gianluca Sartori
September 11, 2012 at 2:05 pm
Some things to check:
1) Remote connections enabled and service restarted on the Express instance (according to your reply, this should be ok)
2) TCP/IP enabled with a static port on the...
-- Gianluca Sartori
September 5, 2012 at 6:16 am
MuraliKrishnan1980 (9/5/2012)
SQL Surfer '66 (9/5/2012)
Is the linked server using the default port 1433? Otherwise you need to specify the port: @server = N'PC068751\SQLEXPRESS,<port>'
Do i need to specify the port number...
-- Gianluca Sartori
September 5, 2012 at 2:45 am
SQL Surfer '66 (9/5/2012)
Is the linked server using the default port 1433? Otherwise you need to specify the port: @server = N'PC068751\SQLEXPRESS,<port>'
True only if the port is static, which is...
-- Gianluca Sartori
September 5, 2012 at 2:44 am
First thing to check: from the SQL Server, can you connect to the SQLExpress instance (with SSMS or SQLCMD)?
If not, there's no need to involve the linked server in your...
-- Gianluca Sartori
September 5, 2012 at 2:42 am
WayneS (9/4/2012)
-- Gianluca Sartori
September 4, 2012 at 9:56 am
WayneS (9/4/2012)
I think I've run across the same limitation, and I've been revamping this script from being process-based to being lock-based. I wanted to add the intra-query parallel processing items,...
-- Gianluca Sartori
September 4, 2012 at 8:23 am
David Burrows (9/4/2012)
Fal (9/3/2012)
Quick poll: how would you pronounce the word "Route"?I'll explain why later, if I'm not too embarrassed. :blink:
Steve.
I am English so naturally /ru?t/
I'm Italian, so naturally...
-- Gianluca Sartori
September 4, 2012 at 2:54 am
Wayne, believe it or not, I've been playing with the script in your blog in the last few days and I have noticed that in some cases the deadlock XML...
-- Gianluca Sartori
September 4, 2012 at 2:47 am
Well, if the system partition is part of a bigger disk shared with the data partition, gparted could be an option.
Take into account that if you enlarge a partition taking...
-- Gianluca Sartori
August 30, 2012 at 10:18 am
Viewing 15 posts - 1,426 through 1,440 (of 5,393 total)