Viewing 15 posts - 13,636 through 13,650 (of 49,552 total)
Couple points...
The ldf is not in the filegroup. Log files are not part of data filegroups.
The primary file (the mdf, file 1) cannot be emptied, there will always be data...
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
April 2, 2013 at 5:37 am
pradeep.mohan (4/2/2013)
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
April 2, 2013 at 5:31 am
Compression algorithms aren't really something you want to write in T-SQL, wrong tool for the job. Have a look at the CLR, there may be some built in functions in...
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
April 2, 2013 at 3:40 am
theashishtrivedi (4/2/2013)
Can you tell me if there is any performance gain, if I maintain the length of VARCHAR as per requirement.
I already answered that, in the first reply.
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
April 2, 2013 at 3:37 am
Not sure if that was a question with all the !!! after it, but...
Use the smallest data types for the data. If something will be 20 characters, use varchar(20). If...
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
April 2, 2013 at 3:23 am
Without more info, no idea.
Please post query, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
April 2, 2013 at 2:58 am
The only compression SQL Server has is table/object compression (look up ALTER INDEX) and backup compression (BACKUP DATABASE ... WITH COMPRESSION)
Could you explain more what you're trying to do here?
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
April 2, 2013 at 2:52 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
April 2, 2013 at 2:48 am
The column that the stats are on is read, the data distribution calculated, the buckets for the histogram selected and populated, the new statistic object written to the database.
Again, what...
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
April 2, 2013 at 2:44 am
No, but if the string will never exceed 200 characters, why consider a varchar(2000)? Max 200 characters = varchar(200)
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
April 2, 2013 at 2:12 am
In what sense? What problem are you trying to solve here?
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
April 2, 2013 at 2:11 am
The point of copying the files is not for a backup, that's what regular, scheduled database backups are for. The file copies are just so that you have files 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
April 1, 2013 at 10:26 am
jack-311987 (4/1/2013)
what if you enable trace flag 708, and use the (noaprilfool) hint
The universe implodes. Please don't try it.
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
April 1, 2013 at 10:16 am
Probably because the active portion of the log is at the end of the file. TRy again later, additonal operations and log backups will have moved the active portion of...
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
April 1, 2013 at 6:34 am
It's not required. Leave it off and the table or index gets created in the default filegroup. That's Primary by default, but can be changed
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
April 1, 2013 at 6:32 am
Viewing 15 posts - 13,636 through 13,650 (of 49,552 total)