Viewing 15 posts - 1,516 through 1,530 (of 49,552 total)
General advice - don't. There's no way from the name you're going to get the gender right. If that's a customers table, then doing so is sooner or later going...
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 20, 2017 at 1:30 pm
bmg002 - Thursday, April 20, 2017 11:21 AMthere was also 8 consistency errors in database 'ACSA'.
Not 'also'
There are 8 errors in the ACSA...
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 20, 2017 at 12:04 pm
NO!
It is NOT a suggestion! It's not the recommended approach.
Asking again,:
Is that on the restored backup, or on the source database that the backup came...
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 20, 2017 at 11:19 am
No. It means that it hasn't been used since the last time the database was started (last time it was restored, or last time SQL Server started)
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 20, 2017 at 10:34 am
Is that on the restored backup, or on the source database that the backup came from?
Should i run the last suggestion: "Repair_allow_data_loss"?
Do you want...
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 20, 2017 at 10:33 am
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 20, 2017 at 9:00 am
Please run the following and post the full and complete output. Run it on both that database and on the source database that the backup came from
[code...
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 20, 2017 at 8:55 am
Can you post the insert statement with its values? It's not going to be coming from the identity column. With a bigint data type it can take numbers far larger...
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 20, 2017 at 7:55 am
No.
The 'multiple files in the filegroup' recommendation is for TempDB, not user databases.
Unless you need to spread over multiple physical drives for performance, there's little reason 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 20, 2017 at 7:52 am
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 19, 2017 at 3:43 pm
Lynn Pettis - Wednesday, April 19, 2017 2:44 PMLooks documented to me: https://technet.microsoft.com/en-us/library/ms177523(v=sql.110).aspx
The variable = expression = expression part 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
April 19, 2017 at 2:58 pm
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 19, 2017 at 2:32 pm
If you can't change the data type, then you need to accept the CAST (and casting the account to INT will give you the same warning). It won't cause cardinality...
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 19, 2017 at 2:16 pm
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 19, 2017 at 1:08 pm
What do you mean by 'library'?
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 19, 2017 at 12:51 pm
Viewing 15 posts - 1,516 through 1,530 (of 49,552 total)