Viewing 15 posts - 20,086 through 20,100 (of 49,552 total)
Honestly, if there are multiple optional parameters I would recommend either dynamic SQL or adding OPTION(RECOMPILE) if you're on SQL 2008 SP2 or above.
While there are various T-SQL methods...
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
February 26, 2012 at 9:28 am
There is a huge amount of difference between a columnstore index and a single column nonclustered index. The architectures are completely different (as you would have seen from the search...
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
February 26, 2012 at 7:02 am
It's stored in a different way (google vertipak storage).
Normal indexes are still stored by row. If you have an index on 3 columns, in the index pages those three columns...
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
February 26, 2012 at 6:28 am
Just as with a non-partitioned table, there can be concurrent inserts depending on the locks taken. If the inserts take row locks, then other inserts can proceed without any problem....
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
February 26, 2012 at 3:51 am
Jeff Moden (2/25/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
February 25, 2012 at 5:02 pm
I'm being deliberately a little vague, see if more information on the scenario presents itself. Can't say I'm optimistic.
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
February 25, 2012 at 12:28 pm
Please go and read that article.
To allow log reuse in full recovery you need log backups. If you don't care about point-in-time restores (as appears to be the case considerign...
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
February 25, 2012 at 12:08 pm
Please read through this - Managing Transaction Logs[/url]
If you're in simple recovery then you don't need a log backup to truncate the log, it happens automatically. If you're in full...
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
February 25, 2012 at 11:15 am
Data file growing usually means that there's been a lot of data added recently. Maybe check see if the size of the tables has increased recently?
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
February 25, 2012 at 9:47 am
Log file large or data file?
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
February 25, 2012 at 8:50 am
Same way you restore any database.
RESTORE DATABASE <db name> FROM DISK = <location>
specify WITH NORECOVERY if there are additional backups (differential or log backups)
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
February 25, 2012 at 8:48 am
Depends whether the inserts are all into the same partition or different ones, depends on how many rows inserted at a time and a bunch more things. It's not 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
February 25, 2012 at 7:41 am
Asked and answered: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=171810
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
February 25, 2012 at 7:37 am
Unless you had something in place at the time the data was deleted (trigger, SQLAudit, etc), there's not much chance you will be able to find this out.
While SQL does...
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
February 25, 2012 at 7:34 am
http://www.sqlservercentral.com/articles/Indexing/68563/
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
February 25, 2012 at 2:33 am
Viewing 15 posts - 20,086 through 20,100 (of 49,552 total)