Viewing 15 posts - 30,376 through 30,390 (of 49,552 total)
Chris Morris-439714 (9/24/2010)
Gail, 'scuse me for being nosey...but what on earth is picture 1? It looks like sunrise through half a dungbeetle or horseshoe crab. Well cool.
Me having fun with...
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
September 24, 2010 at 5:00 am
Sure, but it's terribly complex. Use the system views (sys.objects, sys.columns, sys.indexes.....) to build up queries to get the definitions and then compare the resultsets between the servers. It'll...
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
September 24, 2010 at 4:44 am
Stefan Krzywicki (9/23/2010)
1) Columbus thinks it is a southern town. It snowed one year around 8 inches and it paralized the city.
If it ever snows in JHB such 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
September 24, 2010 at 4:41 am
For jobs like this I recommend getting a copy of RedGate's SQLCompare. It'll likely cost less than the time required to write such a solution from scratch.
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
September 24, 2010 at 4:35 am
shantanusenin (9/24/2010)
i simply asked the reason of the below error
The error message is exceedingly clear in this case
Msg 1919, Level 16, State 1, Line 1
Column 'SourceDomainName' in table 'ITM_Alerts'...
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
September 24, 2010 at 4:31 am
Nope. Need to run an ALTER for each one.
Do note that the encryption is not hard to reverse. At best it'll slow someone down, nothing more.
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
September 24, 2010 at 4:11 am
Your post from yesterday is here: http://www.sqlservercentral.com/Forums/Topic991851-65-1.aspx I requested that it be moved to the SQL 2000 forums as it is a SQL 2000 question.
Duplicate post. No replies to this...
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
September 24, 2010 at 4:07 am
If there's a unique index on the destination table, SQL has to read it to ensure that you aren't trying to insert duplicates.
If there's a non-unique clustered index SQL has...
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
September 24, 2010 at 4:03 am
This isn't a corrupt table, it's a corrupt database.
There's damage to some critical system table. This is not repairable in any way. CheckDB cannot repair the system tables as doing...
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
September 24, 2010 at 4:00 am
The Dixie Flatline (9/23/2010)
You use the word "win" in an odd context, Gail.
Yeah well.. have to learn to joke about that kinda situation.
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
September 23, 2010 at 1:18 pm
What does Books Online say?
http://msdn.microsoft.com/en-us/library/ms188783%28v=SQL.90%29.aspx
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
September 23, 2010 at 12:54 pm
What Steve's suggesting is moving the query from the front end into a stored proc and calling that instead of running the query. Same amount of work as my solution...
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
September 23, 2010 at 12:52 pm
INSERT INTO x (company_id, field1, field2)
SELECT company_id, @value1, @value2 FROM @TempTable
?
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
September 23, 2010 at 12:25 pm
Alvin Ramard (9/23/2010)
GilaMonster (9/23/2010)
Alvin Ramard (9/23/2010)
The Dixie Flatline (9/23/2010)
I don't gamble a lot either, Jason,...
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
September 23, 2010 at 12:16 pm
The Dixie Flatline (9/23/2010)
Want to bet on crime statistics?
If you do, I win.
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
September 23, 2010 at 12:13 pm
Viewing 15 posts - 30,376 through 30,390 (of 49,552 total)