Viewing 15 posts - 76 through 90 (of 312 total)
Attitude of some developers:
/*I don't delete data, but when I do, I do it in prod with no Begin tran and no where clause. I mean who needs where clause? SQL Server...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
October 16, 2018 at 6:32 am
This did work. However, I have a question. Can someone explain why the @@ROWCOUNT = 0 statement was causing the problem with the trigger. I'm assuming since I have two...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
January 4, 2017 at 1:08 pm
grant CREATE procedure TO
GO
grant CREATE FUNCTION TO
GO
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
November 1, 2016 at 9:04 am
Thanks for your kind response but there are 35 tables and all these tables have to be created in 150+ DBs. I already generated the script from the QA environment...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
October 4, 2016 at 1:10 pm
Any help on this?
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
October 5, 2015 at 11:07 am
anthony.green (10/2/2015)
CREATE TABLE #Temp (ParentObject VARCHAR(100), Object VARCHAR(100), Field VARCHAR(100), Value VARCHAR(100))
INSERT INTO #Temp
EXECUTE ('DBCC DBINFO (''YourDBNameHere'') WITH TABLERESULTS')
select
distinct
'Last Known Good DBCC CHECKDB',
Value,
datediff(day,convert(datetime,value),getdate()) AS...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
October 2, 2015 at 10:29 am
Sorry for the confusion. I got it.
Thanks!
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
October 1, 2015 at 2:22 pm
So I am guessing it is not possible to track what data/value is getting inserted.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
May 19, 2015 at 9:44 am
Eirikur Eiriksson (5/18/2015)You can tap into the activities with a trigger, extended events or even a trace, but that might in the end give you even a bigger head ache....
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
May 18, 2015 at 11:57 am
CKX (5/12/2015)
I say this because there is quite a difference between the estimated and actual...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
May 12, 2015 at 8:33 am
Lynn Pettis (5/11/2015)
New Born DBA (5/11/2015)
Lynn Pettis (5/11/2015)So the following (hopefully I mapped everything correctly using the VIEW definition) didn't help:
CREATE NONCLUSTERED INDEX [Test] ON [dbo].[T387]
(
[C6] ASC
)
INCLUDE
(
...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
May 11, 2015 at 2:17 pm
Lynn Pettis (5/11/2015)So the following (hopefully I mapped everything correctly using the VIEW definition) didn't help:
CREATE NONCLUSTERED INDEX [Test] ON [dbo].[T387]
(
[C6] ASC
)
INCLUDE
(
C1,
...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
May 11, 2015 at 1:43 pm
Lynn Pettis (5/11/2015)Show us that index that you had created.
ALTER TABLE [dbo].[T387] ADD PRIMARY KEY CLUSTERED
(
[C6] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
May 11, 2015 at 1:08 pm
CKX (5/11/2015)
I think you may find this particular response from Lynn probably explains what is going on here.
You can experiment by "including" the other columns in your index and see...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
May 11, 2015 at 10:44 am
My question is who says you can't drop and recreate the primary key constraint as a nonclustered index on C1?
My Manager and people who have developed this application.
Putting a clustered...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
May 8, 2015 at 10:38 am
Viewing 15 posts - 76 through 90 (of 312 total)