Viewing 15 posts - 1 through 15 (of 1,199 total)
Your post is quite open-ended and there are many sub-questions. At this point, I will mainly address this point:
Is it possible to derive a column based off another derived column...
June 21, 2022 at 12:20 pm
There are two ways you can set up a linked server:
The default is self-mapping. That is, user A logs in on server S and runs a query against linked server...
June 1, 2022 at 8:09 pm
First of all, what OS do you have? Not very many OSs supports both SQL 2008 R2 and SQL 2017, and if it supports SQL 2008 R2, the OS is...
May 27, 2022 at 7:33 pm
Is this on your private machine or is this in a corporate environment?
In C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log there should be one folder per install attempt. The files of most...
May 19, 2022 at 6:46 pm
Maybe. With the information you have shared there is nothing that makes me scream out NO! However, there is very little you have told us, so there may be something...
May 10, 2022 at 2:10 pm
The full-fledged Express Edition runs as a service. But, localdb runs in user-space so it could serve for a single-user application. Although, I mainly think of localdb as an aide...
May 4, 2022 at 10:39 am
Normally you use the DELETE statement. You don't say which SQL product you are using and I guess the TRUNCATE statement works differently in different products. But I would expect...
April 21, 2022 at 6:39 am
If the batch is a stored procedure called through RPC, DBCC INPUTBUFFER will only give you database id and object id for the procedure. To my knowing there is no...
April 7, 2022 at 6:31 pm
Have a look at https://www.sommarskog.se/query-plan-mysteries.html#dmvgettingplans where I have a query for this.
April 6, 2022 at 6:06 pm
Why not arrange so that they get SSMS and instructions to run your procedures? By time they can learn to write queries themselves. Obviously, you need to make sure that...
March 3, 2022 at 7:31 am
I believe there is a Data Compare option in Visual Studio if you have SSDT installed.
Else you can run queries like this:
SELECT *
FROM dbA.dbo.tbl A
FULL...
December 22, 2021 at 2:26 pm
@Erland - my mistake. I had meant "SQL Server Management Studio presents the date in the format that is configured on the server", not SQL Server.
I believe SSMS always present...
December 1, 2021 at 9:41 pm
SQL Server presents the date in the format that is configured on the server.
SQL Server does not present the date in any format at all! SQL Server is a database...
December 1, 2021 at 8:55 pm
SQL Server 2008 does not have a date data type -- it has datetime & smalldatetime. What is the actual data type in SQL Server?
SQL 2008 does indeed have the...
December 1, 2021 at 8:28 pm
I fired up SSMS17, and it seems that Ctrl+9 was bound to Edit.GotoBrace, which has a different default key binding in SSMS18. I'm not fully certain that this is the...
December 1, 2021 at 8:23 pm
Viewing 15 posts - 1 through 15 (of 1,199 total)