Viewing 15 posts - 12,181 through 12,195 (of 39,963 total)
Take it. Should be easy, just think about how you can teach a beginner to get a plan they can send to someone for remote help (forum, email, etc.)
August 1, 2013 at 5:34 pm
Bump, send me a disaster situation/solution you've dealt with. could be natural disaster, man made, test situation, or user error.
August 1, 2013 at 3:54 pm
I'm not an expert in this area at all. Grant is much better.
That error looks like either a contract isn't set up properly, or it's trying to make a call...
August 1, 2013 at 3:49 pm
DDL would be the table create. Here's a working example in T-SQL
use sandbox;
go
create table Test
( id int
, shipdate date
, shiptime time
)
;
go
insert Test select 1, '1/1/2013', '4:45pm';
go
select * from test
select
...
August 1, 2013 at 12:42 pm
You have to remove the filestream column in the table. Or point it to a new filestream filegroup.
August 1, 2013 at 12:14 pm
left outer joins don't necessarily lock the table. Would like to know where you read that, since it's wrong.
The outer joins often scan the whole table because you may end...
August 1, 2013 at 12:11 pm
Geert Vanhove (8/1/2013)
August 1, 2013 at 11:04 am
SSMS doesn't do this directly, but you can query sys.locks for information. You might start, however, by examining the execution plan and seeing if you have issues with your code.
Why...
August 1, 2013 at 11:03 am
You have to provide more information. What are the data types of the source fields and DDL?
It might be as simple as concatenating the fields and converting to date time.
August 1, 2013 at 11:00 am
It's also entirely possible with your workload that you need the space. There is not set size for tempdb. You need what you need for your workload.
If it grows consistently...
August 1, 2013 at 10:59 am
glad it's working for you. Usually if you install with defaults, the firewall isn't too much of an issue, but it can be frustrating to get it working.
August 1, 2013 at 10:57 am
I'd also note your logic is always going to be split this way. Since someone has access with no rows, you have to account for that separately in your logic...
August 1, 2013 at 10:38 am
patrickmcginnis59 10839 (8/1/2013)
paul.knibbs (8/1/2013)
August 1, 2013 at 10:29 am
RichB (8/1/2013)
I would also firmly point you towards Sidney Dekkers Field Guide to understanding Human Error.In my opinion one of the cross disciplinary must reads for any DBA.
Interesting. Never heard...
August 1, 2013 at 10:26 am
Viewing 15 posts - 12,181 through 12,195 (of 39,963 total)