Good article.

You have to consider that if you created your tempdb with multiple files and especially on another disk then you’ll have to re-check the tempdb because it will be...

If you want to prevent some from the whole set of stored procedures from dropping:

CREATE TRIGGER [TR_PreventDropProcedure] ON DATABASE

FOR DROP_PROCEDURE

AS

BEGIN

SET NOCOUNT ON;

DECLARE @data XML

SET @data = EVENTDATA();

DECLARE @objname nvarchar(200);

DECLARE @objtype...

alexlihw (11/21/2016)

---

Since I have time limit on the reboot progress and I don't want to run the risk of needing to reconfigurate the mirroring and run into some errors. Would...

Hi

If you don't want to have a failover, then you'll have to have a downtime while rebooting.

You can go with ALTER DATABASE XXX SET PARTNER OFF, and then re-establish the...

Thanks,

All those topics is something that I used to study on faculty, but implementation in practice is going slowly 🙂

I'm sure there are some new materials there as well.

A good reminder QotD. Thanks.

Expects the parameter '@Id', which was not supplied:

cmd.Parameters.Add("@Id",SqlDbType.Int);

but here you're supplying the @Name parameter

cmd.Parameters.Add("@Name", SqlDbType.NVarChar, 100).Value = name;

Minnu (11/9/2016)

---

i have below two tables,and am trying to create a view using below statements.

also wants to apply index on view, i cannot apply index on views with UNION.

so i...

No, the schedule can be scripted out. Why not?

Try this query:

DECLARE @database_id int

DECLARE @database_name sysname

DECLARE @sql_string nvarchar(2000)

DECLARE @file_size TABLE

(

[database_name] [sysname] NULL,

[groupid] [smallint] NULL,

[groupname] sysname NULL,

[fileid] [smallint] NULL,

[file_size] [decimal](12, 2)...

Henrico Bekker (11/2/2016)

---

Nice question, technically both:

1. INSERT dbo.TimeZoneOffsetTest (mytime) CAST(SELECT '20161015 08:15 -4:25' as DATETIMEOFFSET)

and

2. INSERT dbo.TimeZoneOffsetTest (mytime) SELECT '20161015 08:15 2:00'

are invalid, option 1 contains an invalid sub-query...

A nice new property in Sql Server 2016. Thanks!

Guras (10/25/2016)

---

Igor Micev (10/25/2016)

---

It's just a...

Derek Knutsen (10/25/2016)

---

But I would also like to put other separate read/write databases on that same instance. Is that possible?

ex:

Report_Server

Prod_DB (Read only - replicated from production_server...

It's just a very calm environment....