Viewing 15 posts - 3,151 through 3,165 (of 6,676 total)
Barkingdog (6/9/2011)
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
June 10, 2011 at 2:45 pm
npeters 86796 (6/7/2011)
the problem i have is that i need to query data using the month in the where clause...
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
June 7, 2011 at 8:35 pm
They are stored in the database - not in the file system.
Your options are:
1) Use BIDS and deploy to the new system
2) Use a tool that will move it for...
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
June 7, 2011 at 8:29 pm
If you have Enterprise Edition - you can install SSRS as a scale-out solution. Basically, you install SSRS on the active node, with the databases configured on an instance...
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
June 7, 2011 at 8:23 pm
Looks like you have a space at the end of the database name. This is causing a problem when trying to access the folder location because you cannot have...
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
June 7, 2011 at 8:19 pm
It is available in the Advanced version - but, there are restrictions so make sure you understand what they are.
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
June 6, 2011 at 7:28 pm
Triality (6/6/2011)
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
June 6, 2011 at 7:26 pm
I believe what you are seeing is expected. SQL Server will utilize as much memory as you allow it.
What SQL Server does is loads data into the buffer cache...
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
June 6, 2011 at 2:06 pm
Shark Energy (6/6/2011)
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
June 6, 2011 at 2:01 pm
sunilg 95099 (6/4/2011)
Can not access database. it is coming in dd-mm-yyyy string format.
What do you mean you cannot access the database? How are you getting the data in the...
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
June 4, 2011 at 7:07 pm
It sounds like you are backing up across the network - which is most likely the largest part of the problem. If possible, change the backups to local storage...
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
June 4, 2011 at 9:34 am
sunilg 95099 (6/4/2011)
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
June 4, 2011 at 9:10 am
sqlnaive (5/24/2011)
Unfortunately that brings me to the same point where I started. In a complex stored procedure, what should be the thumb rule for implementing temporary data [records upto 800].
The...
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
June 3, 2011 at 5:39 pm
Try changing the date format to YYYY-MM-DD instead of YYYYMMDD. If that doesn't work - use the to_date function to convert the string value to a date.
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
June 3, 2011 at 2:24 pm
Jim Murphy (6/1/2011)
Ninja's_RGR'us (6/1/2011)
Find the job that pages you about low freespace to understand how it works.
great advice.
Also I'd put the growth to something more around 1 GB, 100 mb...
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
June 1, 2011 at 2:35 pm
Viewing 15 posts - 3,151 through 3,165 (of 6,676 total)