Viewing 15 posts - 601 through 615 (of 1,162 total)
[sessdata] [ntext] NULL,
This is a LOB. You must have more data in this column on average than you did on your test environment.
This column can store up to 2GB...
October 10, 2011 at 10:30 am
Your average row size is around 44KB, which means your table is either incredibly wide (e.g. lots of varchar/varbinary columns) or you're using LOB's in one way or another (varchar(max),...
October 10, 2011 at 10:02 am
It's a very confusing requirement. So you just need 2 columns which are grouped by year, but you somehow want them to represent 4 different quarters per row??
Do you actually...
October 6, 2011 at 9:37 am
If you're scripting the objects from SSMS, you can also change the default options so it scripts object permissions along with the object. Just go to Tools->Options->SQL Server Object Explorer->Scripting...
October 6, 2011 at 9:10 am
There's nothing built in to do this. You'd need to use a CLR or SSIS script task or similar to connect to one of the Geocoding services; there are a...
October 6, 2011 at 7:56 am
Yes, it's SQL Server 2008 only. In fairness, you did post your question in the SQL Server 2008 forum 🙂
Thanks for coming back and sharing your solution!
October 6, 2011 at 6:53 am
Domestos (10/5/2011)
Thanks HowardW,Could you quickly tell me what the
WHEN MATCHED ANDand
WHEN NOT MATCHEDstatements are matching on? all the fields? or just a primary key?
It's using the ON...
October 5, 2011 at 9:52 am
A MERGE statement is what you're looking for.
You cannot use anything like *, you have to explicitly specify the column names for both the INSERT and UPDATE parts. You can...
October 5, 2011 at 9:22 am
serr4no (10/4/2011)
Would a windows chkdsk in full block-repair mode do much at this stage?
No, almost certainly not.
I would be seeing if the storage team could do more at this...
October 4, 2011 at 7:27 am
How did you do the block level restore? Was it from a Windows Server Backup? You wouldn't normally expect this sort of backup to be so totally corrupted...
Is it possible...
October 4, 2011 at 7:07 am
Ok. Well, there's a few ways to do this, but a couple of options would be:
Use a lookup task to find the ID of the record in myTempTable where it...
October 3, 2011 at 8:22 am
Your description doesn't make it entirely clear what you want to do, but it sounds like you may want to use a "Conditional Split" task to evaluate the data in...
October 3, 2011 at 8:05 am
The code's just wrong.
1) the physical name of the object in tempdb is not documented, so shouldn't be relied upon
2) It won't work for multiple users
3) It only checks what...
October 3, 2011 at 7:40 am
Jack Corbett (10/3/2011)
I agree about the error message. What is vexing to me is that I'm running a trace at the same time and not seeing a better error...
October 3, 2011 at 7:08 am
Jack Corbett (10/3/2011)
HowardW (10/3/2011)
October 3, 2011 at 6:42 am
Viewing 15 posts - 601 through 615 (of 1,162 total)