Viewing 15 posts - 5,176 through 5,190 (of 6,676 total)
What you have is called an np-complete or np-hard problem. It is also referenced as the bin packing problem.
Hugo has a great article on this exact issue at: http://sqlblog.com/blogs/hugo_kornelis/archive/2007/11/30/bin-packing-part-1-setting-a-baseline.aspx
I...
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
May 20, 2009 at 3:34 pm
Scheduling a shrink of your transaction logs every week is a mistake you really don't want to make. Review the article I link to in my signature which explains...
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
May 20, 2009 at 3:10 pm
SELECT MIN(CASE WHEN PeriodId = 1 THEN PeriodEnd END) AS Period1,
MIN(CASE WHEN PeriodId = 2 THEN PeriodEnd END) AS Period2,
...
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
May 20, 2009 at 2:43 pm
Be careful - you might be surprised when you use something like:
SELECT 1.Email, 2.Everything, 3.Else
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
May 20, 2009 at 1:59 pm
Ahh, glad that it settled down for you.
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
May 19, 2009 at 5:29 pm
george sibbald (5/19/2009)
I usually go the backup\restore method but thats really just a personal preference...
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
May 19, 2009 at 5:26 pm
Now, you need to identify what queries are causing the CPU's to spike and fix them. It definitely sounds like you have an underpowered system that could benefit from...
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
May 19, 2009 at 5:18 pm
You should set the max memory to no more than 4GB (4096MB). This will leave 2GB of memory to the OS.
You can also set the lock pages in memory...
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
May 19, 2009 at 4:01 pm
If you have not set lock pages in memory, and you have not set the maximum memory - then you could be seeing issues.
Once again - SQL Server should not...
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
May 19, 2009 at 3:21 pm
balbirsinghsodhi (5/19/2009)
Yes, it's 64 bit machine.
I am thinking of creating two virtual files. One will be the default on c drive and other will be on D drive and...
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
May 19, 2009 at 1:33 pm
SQL Server will use as much memory as you have configured. If you have not set a maximum, it will use as much memory as is available on that...
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
May 19, 2009 at 12:14 pm
They are eithier temp file ie. tm344.tmp or ~vs2E0 sql server query files. But it only fills up when we are running a long sql server query.
You are causing...
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
May 19, 2009 at 10:12 am
A couple of things you could look at instead of using a specific index hint would be to use a query hint or plan guide.
Try using the OPTIMIZE FOR statement...
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
May 18, 2009 at 2:33 pm
I would think the problem is caused because you are using dynamic SQL and you have started the transaction outside the dynamic SQL. Additionally, the way you are coding...
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
May 18, 2009 at 1:39 pm
Redgate provides a fully functional trial version that lasts for 30 days. Who knows - if you download the trial and show it to the right people, they may...
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
May 15, 2009 at 4:48 pm
Viewing 15 posts - 5,176 through 5,190 (of 6,676 total)