Viewing 15 posts - 10,426 through 10,440 (of 49,552 total)
Nope, not that one
DBCC CheckDB('<database name>',REPAIR_ALLOW_DATA_LOSS)
Set the database to single user mode first
You will lose data, not necessarily just the corrupted data, you may lose other data as well. CheckDB...
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
January 13, 2014 at 8:06 am
Varchar.
If the leading 0 is important, then it's not a number. Numbers do not have significant leading 0s, we don't write 0100 for one hundred. We write 0120 for postal...
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
January 13, 2014 at 6:12 am
Koen Verbeeck (1/13/2014)
GilaMonster (1/13/2014)
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
January 13, 2014 at 6:05 am
mxy (1/13/2014)
stored proc need to create a execution plan whenever there is change...
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
January 13, 2014 at 6:05 am
Rodd, do you know anything about the next SQL Bits? I've asked on twitter, silence, web site hasn't been updated in ages. Was hoping to visit the UK for that.
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
January 13, 2014 at 5:28 am
Hakuna Matata (1/13/2014)
The table is high transaction table with hourly job to delete unwanted data. Could this be the issue?
No. The issue is that you have problems with your...
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
January 13, 2014 at 5:17 am
The message is pretty clear
The procedure 'sys.sp_addsrvrolemember' cannot be executed within a transaction
You can't run it within a transaction. Why are you trying?
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
January 13, 2014 at 4:39 am
Attached?
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
January 13, 2014 at 3:51 am
The SQL 2008 exams have all been retired, they can't be written any longer. Have a read through the Microsoft Learning site for the SQL 2012 exams and certifications.
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
January 13, 2014 at 12:37 am
Dynamic SQL doesn't automatically cause performance issues by itself (security issues however...)
What symptoms are you seeing, why do you attribute the problem to the fact that the query is dynamic,...
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
January 13, 2014 at 12:23 am
Fal (1/12/2014)
Just to follow up on a question you posted on the Thread (is that a Threaded question? 😉 You were looking for an editor for the iPad...
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
January 13, 2014 at 12:21 am
Free downloads don't have a serial number. Serial number is what you get when you buy the product. Main Red Gate support for support on their products.
As for exams, browse...
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
January 12, 2014 at 1:02 pm
There's no such thing as a transaction undo file in SQL Server. That not an oracle term?
There are standby files in log shipping which store information relating to undo operations.
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
January 12, 2014 at 1:01 pm
Jeff Moden (1/12/2014)
GilaMonster (1/12/2014)
Please note: 4 year old thread (bumped by a spam post)Why does that matter to you so much?
So that people who don't check the dates don't...
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
January 12, 2014 at 12:54 pm
ramana3327 (1/12/2014)
Thanks Gail. I restored the data file again but still it is showing me that error.
I suggested reinstalling, not restoring a data 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
January 12, 2014 at 12:53 pm
Viewing 15 posts - 10,426 through 10,440 (of 49,552 total)