Viewing 15 posts - 8,416 through 8,430 (of 49,552 total)
It's invalid values (not varchar data) that due to some bug somewhere has snuck into the table. That's about all you can say.
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
July 15, 2014 at 10:32 am
You need to update the column to legal values, consider altering the column later. But there's no guarantee that that is even a legal unicode string. Somehow invalid values 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
July 15, 2014 at 8:38 am
Looks like you have user-defined data types in that database. My guess, Notes is a data type that someone's created at some time. Select Into will keep the same data...
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
July 15, 2014 at 8:32 am
Never use DTA against a production database, it's incredibly dangerous. It's testing workloads so it will put a lot of load on whatever server it's pointing at. If you 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
July 15, 2014 at 8:31 am
Open up Books Online (the SQL help file, F1 in Management Studio), search for UPDATE and have a look at the syntax.
Yes, you can delete and insert, but why would...
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
July 15, 2014 at 7:15 am
If you want to update, then you probably want the UPDATE statement. Again well-documented in Books Online.
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
July 15, 2014 at 6:50 am
Steve Jones - SSC Editor (7/15/2014)
Miss me?
Who are 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
July 15, 2014 at 4:35 am
Only if the applications set that property in the connection strings when they connect to SQL. If they do, you can query the Program_Name column in sys.dm_exec_sessions.
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
July 15, 2014 at 3:11 am
The 0x... Could be XML encoding. REPLACEs are often necessary to fix that. The unfin not coming from the data? Check filters.
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
July 15, 2014 at 2:58 am
Have a look at this (the XML method mainly): https://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/
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
July 15, 2014 at 2:30 am
Alan.B (7/14/2014)
TOP 100 PERCENT is not a kludge nor is TOP <really big number>.
It is kinda. TOP (100) PERCENT ... ORDER BY will result in SQL ignoring the order...
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
July 15, 2014 at 1:06 am
Duplicate post
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1592381-2799-1.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
July 15, 2014 at 12:53 am
Simon Su (7/14/2014)
Will this happen, the DB and mirroring DB are corrupt in the same time? I never thought about this.
Corrupt? Highly unlikely, the chance of two IO subsystems damaging...
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
July 15, 2014 at 12:41 am
Barcelona10 (7/14/2014)
How does Subscriber synchronizes with the Publisher (Merge replication) if it is not using trn log?
It's thoroughly documented in Books Online.
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
July 14, 2014 at 3:50 pm
georgeleonard70 (7/14/2014)
i usedEXEC sp_resetstatus D0011112;
ALTER DATABASE D0011112 SET EMERGENCY
DBCC checkdb(D0011112)
ALTER DATABASE D0011112 SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB (D0011112, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE D0011112 SET MULTI_USER
D0011112 is Suspected Database name
No, no, no!...
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
July 14, 2014 at 3:49 pm
Viewing 15 posts - 8,416 through 8,430 (of 49,552 total)