Viewing 15 posts - 46 through 60 (of 157 total)
Nice article, but I think it could need a second follow up article
May 21, 2021 at 2:07 pm
I manage a big DWH database (about 12 TB). Of course (for this size) the database is partitioned. The biggest tables have their own set of annual filegroups (e.g. FG_ORDERS_2019,...
February 23, 2021 at 10:30 am
we are saying, that #1 and #3 are correct, not #3 and #4.
LEAD with descending order is the same as LAG with ascending order (except that the returned rows are...
February 16, 2021 at 4:10 pm
@scott: The question, if they should cluster for it or not depends, how else this table is used. Yes, 2,400 deletes per day may be a lot, but...
February 9, 2021 at 8:41 am
regarding the clustered index recommentation:
you do not necessary have to cluster your table by MyTime. When MyTime is ascending too (e.g. the creation timestamp) you may e.g. simply selecting the...
February 8, 2021 at 4:17 pm
The link is broken, but I guess, that VS Raavi refers to
https://dataginger.com/2013/05/14/does-sql-server-agent-service-startup-account-must-be-sysadmin/
Even when it's title says, that is about SQL Agent service account, the article refers to both,...
January 7, 2021 at 2:22 pm
Before they are going to add new features, they need to do some very basic stuff to the agent (don't know, if they had only an underpaid junior developer to...
December 23, 2020 at 10:58 am
Regarding to your script:
December 8, 2020 at 1:24 pm
It does not help you in any way to add an identity column to your heaps, it will just add a useless information / memory + disk space (beside the...
December 8, 2020 at 12:57 pm
at https://www.microsoft.com/en-us/download/details.aspx?id=39046 you can download the Kerberos Configuration Manager for SQL Server. It helped me a lot with all this SPN stuff, since it finds out by itself,...
September 10, 2020 at 1:37 pm
Regarding SQL Versions and restore to older versions: the "assuming no new keywords are used" would be a bad sign for a new version.
I don't care about all the fancy...
September 1, 2020 at 12:14 pm
I think triggers can be agood. On the database of my previous employer we had tons of triggers to ensure business logic. Of course you could argue, that it should...
August 13, 2020 at 12:06 pm
why should I do this or how would this work? If I take a single file from a filegroup offline, the data in the file will no longer accessible. And...
August 4, 2020 at 11:36 am
I'd assume that the NoSQL data model fits better for very specific approaches, where you can encapsulate a bigger part of data and assign it to a specific user etc..
Imaging...
July 10, 2020 at 2:10 pm
I had a coworker once (luckily sitting in other room) who was a ~40 years old single and lived in a guesthouse/motel. I don't know, what he did wrong, but...
June 26, 2020 at 4:32 pm
Viewing 15 posts - 46 through 60 (of 157 total)