Viewing 15 posts - 1,426 through 1,440 (of 5,394 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...
September 17, 2012 at 3:46 pm
You can also query that data from the "ms_description" extended property.
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...
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...
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! 😛
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.
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...
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...
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...
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...
September 5, 2012 at 2:42 am
WayneS (9/4/2012)
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,...
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...
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...
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...
August 30, 2012 at 10:18 am
Viewing 15 posts - 1,426 through 1,440 (of 5,394 total)