Viewing 15 posts - 9,706 through 9,720 (of 49,552 total)
If you want to remove all the data in the table, TRUNCATE TABLE.
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
March 12, 2014 at 8:32 am
Not necessarily. Simple may be fine if simple recovery meets the app's requirements for recoverability.
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
March 12, 2014 at 7:18 am
Each query has an associated cost which the query optimiser estimates for it. Upping the cost threshold changes the cost at which the optimiser will generate a parallel plan for...
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
March 12, 2014 at 6:56 am
The log file's there. Log backups can't be done which is why you cannot select any database which is in simple recovery model when the backup type is set 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
March 12, 2014 at 6:41 am
Am I slow today, or was this a little tricky to figure out? http://www.sqlservercentral.com/Forums/Topic1550137-1292-1.aspx
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
March 12, 2014 at 6:32 am
Ah, so it wasn't that the log file wasn't being displayed (which is what your previous posts stated), but that when the Backup Type options is switched Transaction log, 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
March 12, 2014 at 6:30 am
There's no where in the backup database task dialog where the log file is supposed to show up. Where in the dialog do you expect to see the log 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
March 12, 2014 at 6:25 am
Google "New features SQL Server 2014". 1st result: http://msdn.microsoft.com/en-us/library/bb500435%28v=sql.120%29.aspx
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
March 12, 2014 at 5:56 am
You don't have an issue.
The data volume is so low that the clustered index scan is the most efficient option. If the data volume grows to the point where 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
March 12, 2014 at 5:09 am
??
A transaction log backup doesn't need to know the location of the file, it's a backup via SQL Server.
What exactly are you trying to do and what are the exact...
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
March 12, 2014 at 4:58 am
hans.pret (3/12/2014)
It happened previously and the ISP support staff said "I don't know".
Time to change ISP?
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
March 12, 2014 at 4:54 am
Probably because with only 3 rows in the table there's no point in doing anything else as the clustered index scan is the most efficient at that tiny data size.
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
March 12, 2014 at 4:03 am
GilaMonster (3/12/2014)
Grow the file or add more disk space as appropriate.
and run a DBCC updateUsage to fix that negative free space.
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
March 12, 2014 at 4:00 am
You need two nonclustered indexes, one on each of the columns in the where clause.
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
March 12, 2014 at 3:32 am
What are the current indexes on that table?
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
March 12, 2014 at 3:23 am
Viewing 15 posts - 9,706 through 9,720 (of 49,552 total)