Can you ask the DBA to modify the database recovery model or to set up log backup?

Adi

I've done few mistakes. Should have checked it better. The first mistake was that for some reason without noticing it, I've done a small modification in my...

Here is one more way:

declare @Org varchar(150) = 'Lorem ipsum dolor sit amet, CONSECtetur adipiSCIng elit. PelleNTesque in ELIT ut ex accumsan sagittis in a urna'

declare @Results varchar(200) = ''

declare...

Can you check the server's error log? By default it is configured to write into the error log details about failed logins. You'll be able to see there...

In most environments I work with SSMS that is installed on my workstation. Advantages:

1)I can register servers and use groups when I want to run some scripts on few...

Glad I could help:-)

Adi

You can also have a look at piecemeal backup and restore that lets you backup or restore specific files and/or file groups. I have to admit that I've never...

Unfortuetly this is by design. When SQL Server creates the query plan for an ad-hoc query, it doesn't know what will be the value of the variables, so it...

I don't think that it will work. You can't delete data from a snapshot. The snapshot database is a read only database.

Adi

As far as I know, you can only update the statistics on the primary server and it will also update the statistics on the secondary replica. I don't think...

Have a look at the code bellow. I think that this is what you are looking for.

create table #t (dc decimal (10,9))

go

insert into #t (dc)

select 6.25 * rand() +...

You are correct. There is no need to run a daily job that shrinks the file, just to see it grow again after few hours. Nothing will be...

ChrisM@Work (8/2/2016)

---

Adi Cohn-120898 (8/2/2016)

---

A deadlock can occur only on resources that multiple sessions can work with. Local temporary table can be used by one session only (the one that...

A deadlock can occur only on resources that multiple sessions can work with. Local temporary table can be used by one session only (the one that was created them),...

Notice that it will use more memory even if you'll use another length and not just nvarchar(max). The reason is that SQL Server has no statistics about the actual...