Viewing 15 posts - 8,131 through 8,145 (of 49,552 total)
faisalfarouqi (8/13/2014)
What if I delete the file entry from sys.master_files..will that help
The system tables cannot be edited. Edit: And even if they could, the DB is not online, so you...
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
August 13, 2014 at 2:40 am
IsNumeric returning 1 means that the value can be converted to one or more of the 'numeric' data types (int, float, numeric, money). Which one is the question....
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
August 13, 2014 at 2:16 am
SQL Galaxy (8/13/2014)
what could be reason log chain will be broken?
Missing log backup file (deleted) or the DB was switched to simple recovery sometime during that time period.
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
August 13, 2014 at 2:13 am
faisalfarouqi (8/13/2014)
However, can I do a detach, and possibly while attaching it back remove those file entries.
You can, and the attach will fail.
You need to find that 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
August 13, 2014 at 2:12 am
You said files
Other database's log files? Can you move some other file elsewhere temporarily?
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
August 13, 2014 at 1:20 am
What files are on this drive? The database's data file, log file? What else?
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
August 13, 2014 at 12:57 am
Case 1, correct. If you can't take a tail-log backup, then you can only restore to the last log backup you have.
Case 2, Full backups DO NOT and NEVER have...
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
August 13, 2014 at 12:55 am
Eirikur Eiriksson (8/13/2014)
Quick thought, if the indexes cannot be partition-aligned, how about dropping them before the switch and then re-create them?
^^ This is what you'd have to do
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
August 13, 2014 at 12:53 am
You need to either find that file (P:\Mnt\DATA4B\CDW_F_MOBILE_INSTRU_FACT_20140705_4_OLD.ndf) or restore a backup of the database.
The file, whatever it is, is a critical part of the database. Probably part 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
August 13, 2014 at 12:39 am
sqlfriends (8/12/2014)
Does that mean all the read and write should go through stored procedures?for example even select from a table need to write a procedure to achieve?
That would be nice....
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
August 12, 2014 at 3:48 pm
You cannot switch if there are indexes which are not partition-aligned (created on the same partition scheme as the table). Since you have unpartitioned indexes, you cannot perform a switch...
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
August 12, 2014 at 3:46 pm
I'd love some rain. It's getting towards the end of winter here and it is soooo dry.
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
August 12, 2014 at 2:31 pm
The inline syntax is needed for hekaton tables because they're like table vars in that once created they cannot be changed. The fact that it works on normal tables as...
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
August 12, 2014 at 2:29 pm
What are the error messages? I don't have all of the error codes memorised.
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
August 12, 2014 at 9:42 am
SQLRNNR (8/12/2014)
Lynn Pettis (8/12/2014)
Beatrix Kiddo (8/12/2014)
Tweeting about my mistake. I was only trying to help. I didn't suggest doing anything dangerous.
Well, I know at least one person who is totally...
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
August 12, 2014 at 9:03 am
Viewing 15 posts - 8,131 through 8,145 (of 49,552 total)