Viewing 15 posts - 91 through 105 (of 405 total)
Thanks Kenneth
I have used GO separator recursion logic for deleting batches/loading dummy data in development test environments in one time tasks. Good reminder to be careful with your...
July 27, 2016 at 3:52 am
Wrap the insert inside a try block and inside the catch block insert to a different table with @mid defined as varchar(50). You would at least know what is happening...
July 26, 2016 at 3:39 am
John Mitchell-245523 (7/8/2016)
Get sp_whoisactive and run it when you see the blocking. That'll tell you who or what is doing it, and you can ask or force them to...
July 8, 2016 at 7:42 am
So your excel file should be containing the department I guess. The proper way is to import the excel to a table and then you can use it as a...
July 7, 2016 at 10:19 am
Hi Kdanaipam,
This is a SQL server forum. However is there any SQL error you are getting? What do you mean by cascade delete? have you created the FK with' on...
June 30, 2016 at 7:20 am
spaghettidba (6/28/2016)
Absolutely not. Network issues do not trigger anything on the procedure cache.
+1
As long as the instance not restarted, or someone manually clears using DBCC, or if all your Sps...
June 28, 2016 at 4:45 am
David Conn (6/28/2016)
I'd only just done one of these when the Question arrived.
Same here 🙂
June 28, 2016 at 4:40 am
The query is more confusing now. Are you trying to compare columns between the two queries in the union? This in not possible.
June 28, 2016 at 4:37 am
spaghettidba (6/28/2016)
However, the message indicates that you're comparing the column "Quantity"...
June 28, 2016 at 4:12 am
If you provide table definition as something like below, it is easier to help
Create table [dbo].[1]
(
InvoiceNum INt,
customernum INt,
InvoiceDate Datetime
)
Go
Create table [dbo].[2]
(
InvoiceNum INt,
customernum INt,
InvoiceDate Datetime
)
I am assuming your table definition above.
You...
June 10, 2016 at 4:53 am
What does the following return?
SELECT
(physical_memory_in_use_kb/1024) AS Memory_usedby_Sqlserver_MB,
(locked_page_allocations_kb/1024) AS Locked_pages_used_Sqlserver_MB,
(total_virtual_address_space_kb/1024) AS Total_VAS_in_MB,
process_physical_memory_low,
process_virtual_memory_low
FROM sys.dm_os_process_memory;
June 9, 2016 at 2:50 am
Eric M Russell (6/7/2016)
They're asking the wrong type of questions for a job interview.
Yup. But it would be a good homework after a training session on string functions.
June 7, 2016 at 8:48 am
Error for SQL server, is invalid connection string
\\srv-apps01\BCMMaster
are you trying to connect a named instance? then it should probably be srv-apps01\BCMMaster.
June 7, 2016 at 7:39 am
Charlene, in your case this still could be corruption. Did you try DBCC?
June 7, 2016 at 6:50 am
Viewing 15 posts - 91 through 105 (of 405 total)