Viewing 15 posts - 1,516 through 1,530 (of 49,571 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...
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...
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...
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)
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...
April 20, 2017 at 10:33 am
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...
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...
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...
April 20, 2017 at 7:52 am
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....
April 19, 2017 at 2:58 pm
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...
April 19, 2017 at 2:16 pm
April 19, 2017 at 1:08 pm
What do you mean by 'library'?
April 19, 2017 at 12:51 pm
Viewing 15 posts - 1,516 through 1,530 (of 49,571 total)