Viewing 15 posts - 91 through 105 (of 157 total)
The whole, valid command would be (plus maybe some with-options)RESTORE VERIFYONLY FROM DISK='\\SERVER1\Backup\my_big_db\FULL\SERVER1_my_big_db_FULL_20180803_210600.bak'
Sorry, but checking the disk space does not make any sense, since I do...
August 6, 2018 at 5:43 am
Question: why does Windows want / need more free space for itself on systems with more RAM than on systems with lesser?
The "core" of Windows should need...
June 26, 2018 at 2:09 am
I see, what you mean - when developer A works on a procedure for 4 days and developer B makes a small change (e.g. a new column or fixing a...
June 19, 2018 at 2:48 am
An important point, when working with own migration scripts, is defensive scripting. Do not just create a table, but check, if the table already exists before. The same with columns...
June 19, 2018 at 12:46 am
I used to comment every line of code, when I wrote scripts for the game Heroes of Migth and Magic 3 (WoG), but mostly, because it had a very "uncommon"...
June 13, 2018 at 6:46 am
it depends :-), but both queries could return different results when are used with real tables.
Your first query (with UNION ALL) could return duplicates, when you have the...
June 12, 2018 at 7:42 am
Nice question, but when you use country specific date / time conversion, you should always add a SET language = 'englisch' to the query.
On my German SQL Server...
May 4, 2018 at 4:21 am
You are right about the missing OVER() in the third query - sorry, my fault,
On the other side the execution plans for query one and two are not...
March 27, 2018 at 3:34 am
This is a little inconsistency, since you can't set CONTEXT_INFO to NULL.DECLARE @ci VARBINARY(128) = CONTEXT_INFO();
--<do some stuff as temporary setting CONTEXT_INFO to something else>
SET...
March 9, 2018 at 12:52 am
I'd guess that there are a lot of small and big shops out there, which uses bcp and sqlcmd regulary (e.g. bcp for simple import / export tasks where SSIS...
March 5, 2018 at 12:56 am
Another problem: JSON could be stored in a (N)VARCHAR(MAX) field which could not be added to an index (only included, but this would only allow full index scans, even if...
February 27, 2018 at 8:11 am
What happens, if you call the procedure again with an ID which has only one entry (so that the granted memory is now much to high)? Will it lower the...
February 1, 2018 at 1:04 am
I'm confused - the MS page you linked in your answer says in its head:
THIS TOPIC APPLIES TO: SQL Server (starting with 2016)
So...
January 29, 2018 at 2:08 am
Heterogenity may sound nice, but if I have x different systems, it multiplies the number of vulnerabilities too. And of course I would need staff, which knows this systems very...
January 25, 2018 at 1:40 am
Why is usefull stuff as this deprecated? Everyone is talking about normalisation, but I still have to write the same code in a CHECK CONSTRAINT again and again and again,...
January 12, 2018 at 1:22 am
Viewing 15 posts - 91 through 105 (of 157 total)