|
|
-
Gopi Commented 1 Months ago through Blogs
Hi,
'C:\FileGroupDB_Log_1.ldf' is log file or data file? Second image says its "data only". Is that log file or data file?
Thanks
Gopi...
|
-
Gopi Commented 6 Months ago through Blogs
But if #t is created again in child proc, then SQL Server engine treats both as different #table.
alter procedure proc_1
as
create table #t(i int)
--insert into #t select 5
exec proc_2
select i from #t
go
alter procedure proc_2
as
create...
|
-
Gopi Liked 8 Months ago through Pages
We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...
|
|
|
-
Gopi Liked 2 Years ago through Syndicated Blogs
When a transaction happens, say for an example data is bening inserted, there are mainly two things happens:
1. data page in the buffer cache is updated.
2. Data is written to the log cache.(This is to ensure the ACID property incase of any rollback...
|
-
Gopi Commented 2 Years ago through Syndicated Blogs
Hi,
I am not sure if im correct to your question. When TRANSACTION is not defined explicity then implicit transaction will occur for every INSERT inside the loop. This is similar to --Test-1 is the fisrt example. Hence task count of wait task count ...
|
-
Gopi Commented 2 Years ago through Blogs
Hi,
I am not sure if im correct to your question. When TRANSACTION is not defined explicity then implicit transaction will occur for every INSERT inside the loop. This is similar to --Test-1 is the fisrt example. Hence task count of wait task count ...
|
-
This challenge is about finding second highest salary for each department...
|
|
|
|
|