Viewing 15 posts - 7,996 through 8,010 (of 9,707 total)
One of our corporate teams monitors that sort of thing for us (Server is offsite) and notified us of these problems. Some alerts are auto, some are manual.
Our cluster service...
April 30, 2010 at 6:28 am
Wow. I need to add an example like this into my SQL Saturday JOINS class.
Good catch, Jason.
April 30, 2010 at 6:23 am
Henrico Bekker (4/29/2010)
No matter what the answers, testing on production servers is never a good idea.
I have to whole-heartedly agree with this sentiment. Create a Dev server setup and test...
April 30, 2010 at 6:21 am
Better choice indeed. SQL 2k8 gives you so many more options that 2k. But you will have a LOT of code & stuff to upgrade, so get ready to work...
April 30, 2010 at 6:20 am
Maybe this is the old way of doing it... I'd never heard of sys.master_files before.
Use MyDB;
GO
Select * from sysfiles;
(Yes, I know using * is bad, but it's a tiny table).
April 30, 2010 at 6:18 am
Ditto to what Grant said.
I'm curious. What answer did you give in the interview?
April 30, 2010 at 6:16 am
It definitely sounds like she's using two different permission sets or that the client tools on her workstation were installed wrong.
What perms does she have? Does she log into the...
April 30, 2010 at 6:15 am
Mani-584606 (4/29/2010)
Why dont you try shrinking the log ????
I'm NOT sure whether we can shrink the log file size for TempDB or not? I believe it's NOT a good...
April 30, 2010 at 6:13 am
When you retrieve this data, are you only pulling it from one database? Are you connected to that database?
Are you pulling from multiple DBs? Are you using a Linked Server?
April 30, 2010 at 6:11 am
Depends on ownership chaining. Does the same schema own both the view and the table?
April 30, 2010 at 6:09 am
Have you tried right-clicking the Logshipped DB in SSM and going to Properties? You should be able to change the owner there.
Then again, I don't have a logshipped DB to...
April 30, 2010 at 6:08 am
Without knowing the structure of your database or your query, we can't answer that question. Performance depends on too many things for us to blindly say "XYZ".
Post your query with...
April 30, 2010 at 6:06 am
The problem is, you're asking the question in a vacuum of information. Maybe if you tell us what point you're trying to prove or disprove, we could assist you better.
Server...
April 30, 2010 at 6:04 am
You're quite welcome.
Given your description, though, I'm betting it's a combination of too many connections and not a big enough paging file.
April 30, 2010 at 4:35 am
Joy Smith San (4/30/2010)
Many of the prior replies noted Transparent Data Encryption as an option. It was also noted that TDE encrypts the physical data files and not the data...
April 30, 2010 at 4:29 am
Viewing 15 posts - 7,996 through 8,010 (of 9,707 total)