Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,836 through 17,850 (of 59,069 total)

RE: How does SQL detect if a database backup was done?

Here's what I'm talking about... this checks to find out what the current recovery model is so that you can make better decisions as to what kind of backup is...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 17, 2016 at 12:38 pm

#1872619
RE: How does SQL detect if a database backup was done?

Jeff Moden (4/17/2016)
This should help you get started...
SELECT LastFullBackupDT = MAX(backup_finish_date)
FROM msdb.dbo.backupset
WHERE database_name = 'yourdatabasenamehere'
AND recovery_model...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 17, 2016 at 11:56 am

#1872613
RE: How does SQL detect if a database backup was done?

This should help you get started...
SELECT LastFullBackupDT = MAX(backup_finish_date)
FROM msdb.dbo.backupset
WHERE database_name = 'yourdatabasenamehere'
AND recovery_model <>...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 17, 2016 at 11:49 am

#1872611
RE: iam page

avraham.elad (4/17/2016)
hi ,
i dont understand iam pagei read sevral post and is dont get it,
somone please explain this without qoute msdn ?
Without knowing why you need to understand IAM...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 17, 2016 at 10:45 am

#1872604
RE: Successful Projects

manie (4/15/2016)
It would be interesting to find out what percentage of the world's programmers rely on forums like SSC to actually do their job (sorry, have the job done for...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 17, 2016 at 10:05 am

#1872603
RE: Cannot connect to (local) - how can I copy databases to another computer?

Just in case you've not already tried...
Since this isn't a production box, do the "normal" thing... something may have gone haywire with Windows or SQL Server express. Try rebooting...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 17, 2016 at 8:53 am

#1872600
RE: Aggregate data in a row-like fashion

qwerty.qwertz (4/17/2016)
I have a SQL input table that is structured like the one shown below. Based on this input table I wanna create another table that aggregates the information in...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 17, 2016 at 8:42 am

#1872599
RE: Loading files in parallel

richardmgreen1 (4/14/2016)
Hi Jeff
If only......
We get the CSV files as a data extract (I haven't got a clue what format the back end of the application runs on).
This is also a...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 17, 2016 at 8:27 am

#1872598
RE: Trigger for incrementing

fareedhmohamed (4/17/2016)
USE [Supermarket]
GO
/****** Object: Table [dbo].[Customer] Script Date: 17/04/2016 13:44:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Customer](
[CustomerID] [varchar](10) NOT NULL,
[FirstName] [nvarchar](50) NULL,
[Surname] [nvarchar](50) NULL,
[Gender]...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 17, 2016 at 7:45 am

#1872596
RE: Select records in hierarchical order

If you click the QUOTE button on this post, you'll see how to use the "IFCode Shortcuts" that you can see to the left of your post when you're creating...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 16, 2016 at 7:34 pm

#1872572
RE: Comparing doc or pdf Files from Using SQL Server

natigsqlserver (4/16/2016)
hi friends
i have very interesting qeustion
can we comparing two another files with sql server
for example
in varbinary column have a pdf format file
in inserting new data in...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 16, 2016 at 11:39 am

#1872566
RE: The USE command and variables

Jeff Moden (4/15/2016)
Sgar... (4/15/2016)
In above examples you have used Set @dbname= 'database name'.
I am taking this input from Stored procedure input. How can you help?
I'm curious... have you ever written...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 16, 2016 at 9:02 am

#1872561
RE: Where is my backup?

dxu (4/14/2016)
Hi guys,
I have scheduled full SQL backup on 1AM every morning and then two differential backups on 7AM and 1PM. I have also put hourly log backup in place...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 15, 2016 at 8:44 pm

#1872547
RE: Please help me improve the performance of this query

Heh... wow... this thread certainly jumped the track. 😉
The original post is pretty clear. Everything flies when the last condition is removed even though a shedload of...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 15, 2016 at 8:29 pm

#1872546
RE: The USE command and variables

Sgar... (4/15/2016)
In above examples you have used Set @dbname= 'database name'.
I am taking this input from Stored procedure input. How can you help?
I'm curious... have you ever written a stored...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 15, 2016 at 8:11 pm

#1872545

Viewing 15 posts - 17,836 through 17,850 (of 59,069 total)