Viewing 15 posts - 15,826 through 15,840 (of 49,552 total)
sqlnaive (11/1/2012)
Even i assume going forward, there is also possibility of getting duplicate values in column ColB to the table T1.
Then you cannot define a foreign key and should probably...
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
November 1, 2012 at 9:03 am
Two ways to take a tail log backup.
1) The DB is online and usable and you want to backup the last of the transactions before starting a restore/moving the DB/etc...
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
November 1, 2012 at 8:30 am
Dependencies should be enforced with foreign keys, not with triggers.
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
November 1, 2012 at 7:49 am
The column in the referenced table must be unique, a foreign key defines a 1-n relationship, not an n-m. So if ColB is unique, you can do this (but 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
November 1, 2012 at 7:48 am
Just changing ntext to nvarchar(max) is not going to magically make queries significantly faster. You need to identify what's slow and tune those queries.
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
November 1, 2012 at 7:24 am
sanket kokane (11/1/2012)
you can create index on varchar which is not possible on ntext.
You can't create an index on an nvarchar(max), which is the replacement for ntext. Just replacing 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
November 1, 2012 at 6:08 am
Exam centre I wrote at had 15" CRT monitor, keyboard out of last century and a 400+ms network latency to Redmond. If I have to write a lab exam again,...
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
November 1, 2012 at 6:06 am
Probably not.
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
November 1, 2012 at 5:02 am
Nope, not for MSDB. Just stop SQL Agent.
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
November 1, 2012 at 5:01 am
As I said, if you have a clean backup, I suggest you restore it.
As for the cause - IO subsystem problems of some form. That's what 99% of corruption 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
November 1, 2012 at 4:03 am
Not event viewer. The SQL Server error log. (Those log entries are in the application event log too, often harder to find among all events from all the other apps)
It's...
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
November 1, 2012 at 4:00 am
Because it doesn't make sense to do so. If you think about an index in a book, the keys are short. NText is a blob store for large amounts 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
November 1, 2012 at 3:57 am
1) Wouldn't know, don't do BI
2) Whichever path makes sense to you. They're all valid, there's no right and wrong here. If you work a lot with 2008 and expect...
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
November 1, 2012 at 3:43 am
That will be in the SQL Server error log.
Just to clarify something Anthony said. Data modifications (insert, update, delete and DDL) are stored in the tran log regardless of 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
November 1, 2012 at 3:39 am
If you have a clean backup of MSDB, I would suggest you restore it. Otherwise repairing this will lose a fair bit of data in the backup history tables
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
November 1, 2012 at 2:46 am
Viewing 15 posts - 15,826 through 15,840 (of 49,552 total)