Viewing 15 posts - 17,251 through 17,265 (of 49,552 total)
Truncate log doesn't work on SQL 2008. The replacement is simple recovery model.
Please read through this - Managing Transaction Logs[/url]
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 10, 2012 at 5:48 am
anthony.green (8/9/2012)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 10, 2012 at 5:47 am
durai nagarajan (8/10/2012)
move it to active- active cluster.this is not exact load balance google for more details i am not an expert in that.
Active-active cluster (more correctly called a multi-instance...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 10, 2012 at 5:45 am
That's a big if, since no such filegroups were mentioned. Also, if bringing the DB to a lower environment (dev/test), those read only filegroups would be needed, though the tables...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 10, 2012 at 5:22 am
kranthi1.aprdc (8/8/2012)
Using SQL Profiler to trace is not supported on production systems.
It's completely supported. It's not recommended on busier servers, but it's fully supported.
p.s. 4 year old thread...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 10, 2012 at 5:20 am
No way to answer that one. Higher than 384, but the higher you set it the more it cuts into the portion of the buffer pool under 2GB (which is...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 10, 2012 at 5:18 am
Books Online, the section bcp (stands for bulk copy program)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 10, 2012 at 5:10 am
Post the code that the app is running and the actual error.
You can't update a computed column (persisted or not), it's calculated. Hence if the app tries to update that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 2, 2012 at 12:14 am
pradeep.mohan (8/1/2012)
when I'm doing mirroring i get the error:
"The remote copy of database "test" does not exist. check the database name and reissue the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 2, 2012 at 12:10 am
XMLSQLNinja (8/1/2012)
This is generally true but, I have also seen cases where the log file fills up the hard drive during a huge insert.
Sure. It happens. Shrinking the log at...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 1, 2012 at 9:33 pm
Don't underestimate the difficulty of the lab exam, it's significantly harder than the knowledge.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 1, 2012 at 9:31 pm
Not on 32 bit. On 32 bit they use the Mem_to_leave area which by default is 384MB.
Setting max server memory lower will accomplish nothing on 32-bit other than to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 1, 2012 at 9:30 pm
And if you can't put another attribute in this database, you put a table into another with a lookup table once you've done the fuzzy lookup.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 1, 2012 at 3:33 pm
Don't shrink the log to 0 (unless the next operation is going to be a grow)
Growing the log is an expensive operation, the file has to be zeroed out and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 1, 2012 at 2:40 pm
Yes, because IF (@Var = NULL) returns UNKNOWN (not true, not false). NOT UNKNOWN is still UNKNOWN.
declare @var as varchar(5)
--set @var = 'value'
If (@var = null)
Begin
Print 'The var =...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 1, 2012 at 12:36 pm
Viewing 15 posts - 17,251 through 17,265 (of 49,552 total)