DJH-445911 (7/7/2015)

---

I Would appreciate some help with the following query...

I have a DB with all user tables containing CreateDate, CreateUser, ModifiedDate, Modified User.

I need the Table name, row count, Min...

Grant Fritchey (7/2/2015)

---

When I taught classes like this where all we were doing was querying, instead of setting up Express (not a bad idea, just not what I needed), I...

There is no official naming convention. Just choose one and stick with it. The most important thing is to be consequent and use the same notation overywhere.

Hi,

To use SQL Express is a very usable solution if you are not using the agent in some way. You need to additionally install the SSMS seprately, becuase it's not...

From the "etails.txt" I read the SQL Service is stopping at some moment. Are there any events logged in the Windows Event log? If so: does it state a cause...

In addition to what Gail mentioned: SQL has no space restriction on the table level. The space is defined at database/filegroup level. When the autogrowth setting on the file(s) of...

Hi

In SSMS 2008 the total size displayed in the properties of the database is including the LOG space. The free space displayed in the properties of the database is excluding...

Hi,

I use the following query to display blocked sessions including the head blocking process.

select

SPID

, sp.Status

, DB_NAME(dbid) as [database]

, (select TEXT from sys.dm_exec_sql_text(sp.sql_handle)) as last_cmd

, open_tran

, blocked

, case when waittime >...

Hilarious! I love this one!

CozzaroNero (5/22/2015)

---

I tried to delete one of the ndf files for the tempDB and got the following error:

DBCC SHRINKFILE: Page 4:24 could not be moved because it is a work...

you can run "sp_who2" or "select * from sys.dm_exec_sessions" when connected to the server. This will show you the active connections. Column "hostname" shows the originating machinename.

The rows with SPID...

My bad... I didn't notice the SSRS forum because...

a quick (and dirty) solution using a TALLY table:

set nocount on

-- set a date variable to the start date of the range

declare @date date

set @date = '20130101'

-- create tally table...

Lynn Pettis has blogged about zome common date-routines. You can use these as a starting point to get your desired dates:

Some Common Date Routines[/url]

There's a workaround posted on the Microsoft Connect site you mentioned:

Gepost door JCBrown79 op 24-2-2014 om 4:44

1. Obtain the original file paths for the database using...