Viewing 15 posts - 91 through 105 (of 166 total)
It seems odd that you wouldn't get some sort of error, instead of having the insert or update just not happen. Anyway, this is a pretty comprehensive explanantion of...
July 22, 2011 at 4:47 pm
The DMV, dm_db_index_physical_stats, also shows the min, max and average row size as min_record_size_in_bytes, max_record_size_in_bytes and avg_record_size_in_bytes.
July 22, 2011 at 1:16 pm
If you search on this subject, you'll likely find those that say that target needs to be less than total. My understanding is that, if total is less than...
July 22, 2011 at 1:11 pm
Don't you just love the questions some people come up with for interviews?
July 22, 2011 at 12:43 pm
You might want to search for sql server high availability options using your favorite serach engine and do some reading. Your choice will depend on a combination of business...
July 22, 2011 at 12:40 pm
That's one way to do this, but I'd probably opt for a server-side trace with a duration filter and then import those into a table for analysis. A trace is...
July 22, 2011 at 12:26 pm
This does that with a union. You could alternately join the two queries to put the results on one row. I'm using SQL Server 2008 for this. ...
July 22, 2011 at 10:50 am
It might be useful to take a look at this too.
July 20, 2011 at 5:01 pm
The you might want to try adding a linked server to that database for testing/troubleshooting, preferably on a development server, and see if you can access it and execute queries....
July 20, 2011 at 4:30 pm
Then I would try executing the code that's in the job in SSMS. If it works, then it might be SQL Agent service account permission issue. Linked servers...
July 20, 2011 at 3:57 pm
Then I would check the path to the Access database in the linked server definition and make sure it exists.
July 20, 2011 at 3:42 pm
Is the linked server for an Access database or a spreadsheet? If it's a spreadsheet, it may be a permissions issue.
July 20, 2011 at 3:29 pm
Sharon,
I'm not sure that I completely understand what you're asking for. Can you provide an example? Thanks.
July 20, 2011 at 1:21 pm
I think that you have to install it on each node, so you might want to check that. The extended stored procedures would be wherever the program is installed....
July 18, 2011 at 12:30 pm
This might work too. You'd have to figure out how to do the calculation.
select ID, Today, Room, StartTime,
(select Max(Endtime) as PreviousStartTime from dbo.TurnaroundTimeData
where Starttime < T.StartTime and Room...
July 8, 2011 at 4:56 pm
Viewing 15 posts - 91 through 105 (of 166 total)