Viewing 15 posts - 1,126 through 1,140 (of 1,838 total)
So I have a question then... since the TSQL command BACKUP DATABASE documentation says "SQL Server backs up enough of the transaction log to produce a consistent database when the...
January 24, 2017 at 6:52 am
maybe you could use a version of the quirky update often used for running totals, using a temp table with an extra aggVal column?
CREATE TABLE #bits...
January 20, 2017 at 2:31 pm
January 20, 2017 at 1:57 pm
January 20, 2017 at 11:14 am
The way I understand it, for a given task in the execution plan, Operator cost is IO cost + CPU cost. Subtree cost is the cost of the task and...
January 20, 2017 at 10:20 am
Database mail uses a queue and Service Broker to handle the sending of mail, and it will activate when necessary. It is normal to see the process that handles this...
January 18, 2017 at 2:35 pm
sqlfriends - Wednesday, January 18, 2017 11:34 AMwhat is pass through queries? thanks
Pass-through queries are a feature within Access that let you...
January 18, 2017 at 2:17 pm
January 18, 2017 at 11:29 am
ALTER TRIGGER [dbo].[tr_datediff] ON [dbo] [JOURNAL] FOR INSERT,UPDATE
AS
SELECT DATEDIFF(d,start_date,end_date) [diff],[TimeDiff] FROM JOURNALstart_date is datetime
end_date is datetime
TimeDiff...
January 16, 2017 at 10:09 am
Here's a query I use to search SQL Agent jobs for a database name reference, I search the command and the database setting since it could be either way:
January 16, 2017 at 9:35 am
On sunday morning I had an overnight issue with a late ETL build
Not necessarily an...
January 16, 2017 at 9:27 am
SELECT s.name + N'.' + t.name AS table_name, i.name AS index_name, i.type_desc, i.is_unique, i.is_primary_key,
SubString(
(SELECT N', ' + c.name + CASE WHEN ic.is_descending_key = 1 THEN...
January 13, 2017 at 1:09 pm
It's available in SYS.indexes as the filter_definition column.
this is a query I use to quickly see all the indexes on a table or list of tables:
for some...
January 13, 2017 at 10:27 am
jasona.work (1/10/2017)
...I mean really, how bad can the roads get in a hurricane, it's just water on the roads?😉
And a lot of wind too, I remember comedian Ron White said...
January 10, 2017 at 2:36 pm
version and clustering may have something to do with it as well. I notice if I connect to a clustered SQL Server 2014 database with SSMS 2008 R2, I...
January 9, 2017 at 1:39 pm
Viewing 15 posts - 1,126 through 1,140 (of 1,838 total)