Viewing 15 posts - 2,026 through 2,040 (of 6,041 total)
For what it's worth, the @@ROWCOUNT system variable contains the number of rows affected by the immediately preceeding DML operation.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 17, 2016 at 11:53 am
Gary Varga (11/17/2016)
It does appear that the Azure first policy is certainly bearing the fruits of their labours.
What is the first policy?
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 17, 2016 at 10:54 am
Especially for lower tier servers (ie: 4 CPU / 8 GB memory), or instances where the database engine is the only service running, it's hard to justify the OS memory...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 17, 2016 at 8:19 am
comic_rage (11/16/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 16, 2016 at 1:55 pm
comic_rage (11/16/2016)
I have the following query that is returning 1.6 M rows and about 300 columns. I can't change this factor. Here is the current
query
select Column1 ... Column290
from dob.table1
where...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 16, 2016 at 12:13 pm
In T-SQL there is an IGNORE_DUP_KEY option that can be added to the primary key. Unlike MySQL's ON DUPLICATE keyword, it doesn't result in an update for a row with...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 16, 2016 at 11:42 am
There are some good articles on this site related to event Auditing, including how to filter for specific types of operations and users. http://www.sqlservercentral.com/articles/Stairway+Series/130498/
You can also fall back to using...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 16, 2016 at 11:00 am
Start with learning how to live up to your formal job description. Ask your immediate supervisor what's expected of you in terms of roles. You don't want to focus on...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 16, 2016 at 9:47 am
When running sp_who2 or DMV queries from SSMS, rather than filtering on 'SA', perhaps excluding your own SPID is what you really want. It's entirely possible that another DBA (or...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 16, 2016 at 9:39 am
When it comes to choice of database, it helps to understand that some platforms are much better suited for staging large amounts of data (ie: Hadoop or Cassandra), some databases...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 16, 2016 at 9:22 am
This is a long shot, but assuming the user who executed the DELETE operation is still connection, and the last command they executed as the DELETE, then it should work....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 16, 2016 at 8:14 am
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 16, 2016 at 7:34 am
Are the production staging tables to be entirely deleted (truncated), or will you delete only rows aged within a specific date range?
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 16, 2016 at 7:31 am
If you discover it to be a timing issue, and the job step can be repeated to completion, then consider going under Advanced properties of the step and setting it...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 16, 2016 at 7:28 am
If MERGE isn't an option, then perhaps something like the following (pseudo-code of course). This way, if the row does happen to exist, then it's a single lookup.
UPDATE ... WHERE...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 15, 2016 at 1:34 pm
Viewing 15 posts - 2,026 through 2,040 (of 6,041 total)