Viewing 15 posts - 3,676 through 3,690 (of 6,676 total)
To be able to use SQL Server functionality in a normal powershell session, you have to include the powershell provider for SQL Server.
http://msdn.microsoft.com/en-us/library/cc281962.aspx
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 18, 2010 at 9:08 am
sushantkumar1984 (7/16/2010)
But my database restores starts from 10%, 20% , 30% ...then it stops in between....
it is not that it doesnt start...but after sometime it throws error.
The article...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 18, 2010 at 8:49 am
This might be the issue you are running into: http://support.microsoft.com/kb/843515
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 16, 2010 at 8:36 am
CirquedeSQLeil (7/13/2010)
Anybody have a good source concerning the "don't index tables with less than 1000 rows" optimization technique?
Read Paul Randall's blog on this subject.
http://www.sqlskills.com/BLOGS/PAUL/category/Indexes-From-Every-Angle.aspx#p4
Basically, he made them up...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 13, 2010 at 7:41 pm
You can use the backup_set_id column in the backupset table in msdb. There are scripts available that can be used to generate the restore script for you.
Search this site...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 13, 2010 at 2:01 pm
You do not need to cycle SQL Server for this change. Changing memory is dynamic and the additional memory will be immediately available.
The only time you need to cycle...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 13, 2010 at 11:53 am
This is a network issue - there is something that is causing that system to lose connection with the network or that other system.
Copy the backup files local and restore...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 12, 2010 at 2:32 pm
If the size of the database is small (< 4GB), and there are not a lot of users of the system, you can probably get this done by installing SQL...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 12, 2010 at 2:29 pm
thinknight (7/10/2010)
Max Server Memory (MBs) 13312Min Server Memory (MBs) 13312
Thanks - at least that clears up whether or not that is set correctly. Now, I wouldn't set min...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 10, 2010 at 8:11 pm
Okay - I'll ask this again what are the exact values you used to set max memory. To clarify my concern is that a lot of people have set...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 10, 2010 at 2:34 pm
And if you really want to get into the higher paying jobs - you need to know the business that you support.
DBA + Operations (system admin, SAN, etc...) + Healthcare...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 9, 2010 at 7:33 pm
Because the clustered index is the table - and the table has a text column. If the index was a non-clustered index, you could rebuild it online because it...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 9, 2010 at 7:29 pm
What are the exact values you are using to specify the max memory? How are you determining how much memory SQL Server is using?
You should use perfmon to determine...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 9, 2010 at 2:01 pm
Explicitly grant permissions on the schema, for example:
GRANT EXECUTE ON SCHEMA::myschema TO myroleoruser;
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 9, 2010 at 1:47 pm
george sibbald (7/7/2010)
Jeffrey Williams-493691 (7/7/2010)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 7, 2010 at 7:44 pm
Viewing 15 posts - 3,676 through 3,690 (of 6,676 total)