Viewing 15 posts - 3,841 through 3,855 (of 49,552 total)
You need to use an update. Yes, update replaces the value, so make the new value contain the old.
UPDATE SomeTable
SET SomeColumn = SomeColumn + 'Another string value'
btw, this is a...
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 14, 2016 at 12:43 pm
chuck.forbes (1/14/2016)
Looks like it defaults to something called an "event stream".
Shawn Melton (1/14/2016)
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 14, 2016 at 12:42 pm
Then that's your problem, not the maintenance. With no indexes at all, no clustered index, the table is a heap. Firstly index rebuilds won't touch heaps, second deletes don't deallocate...
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 14, 2016 at 11:20 am
As I said,
GilaMonster (1/13/2016)
Don't restore system databases from one instance to another, doing so is asking for subtle problems.
Distribution *is* a system database.
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 14, 2016 at 11:08 am
MAX_DISPATCH_LATENCY=30 SECONDS
Events don't show up instantly in the live data view. They're not dispatched instantly either. Run your queries, wait a bit (oh and make sure that you started 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
January 14, 2016 at 10:24 am
What indexes does that table 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
January 14, 2016 at 10:03 am
sqlnewbie17 (1/14/2016)
If my result set has a million rows wouldn't a case statement be very slow than a where clause.
That's pretty immaterial. To do what you want requires a case...
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 14, 2016 at 7:54 am
er.mayankshukla (1/14/2016)
But, in what scenario adding clustered index keys in unique non clustered index can be useful since the unique non clustered index has unique column which is easily seekable
And...
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 14, 2016 at 2:58 am
This is the reason we don’t include Clustered index columns in Non Clustered indexes because even though you mention clustered index columns as a part of your non-clustered index key...
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, 2016 at 11:54 pm
Go into the maintenance plan and enable logging. You need to see the actual error to fix whatever's wrong.
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, 2016 at 11:49 pm
vamshikrishnaeee (8/10/2010)
If I partition the table with 4 columns then I may get better performance.
Nope.
If you're looking for improved performance, don't waste your time fiddling with partitioning. Partitioning is for...
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, 2016 at 11:48 pm
Don't restore system databases from one instance to another, doing so is asking for subtle problems.
Script the logins, linked servers, config settings, roles, jobs, replication out and use those scripts.
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, 2016 at 1:50 pm
No. Master can't be restored from any other version, and to be honest you shouldn't be moving most system DBs from one server to another. Script their contents, recreate. In...
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, 2016 at 8:52 am
Within the trigger, something like
INSERT INTO AnotherTable
SELECT <whatever columns needed> FROM inserted;
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, 2016 at 8:45 am
Join to sys.dm_exec_requests on sessionID and then CROSS APPLY to sys.dm_exec_sql_text using the sql_handle column in exec_requests. I think the column's there in SQL 2008.
Alternately if you know there's a...
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, 2016 at 8:41 am
Viewing 15 posts - 3,841 through 3,855 (of 49,552 total)