Viewing 12 posts - 61 through 73 (of 73 total)
Thank you all dear!!
It was Independence day of India, so I couldn't reply.
Thank you once again, hope this was helpful to all.
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
August 17, 2014 at 10:19 pm
Sure dear!,
I will use your query, I have tested this. seems good. Thanks once again.
Hope this will helpful to all.
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
August 13, 2014 at 10:27 pm
Thanks ChrisM@Work for your comment. I got the tone.
Generally UDFs are slow as compare to same query.
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
August 13, 2014 at 4:30 am
subhanshu-khurana (8/12/2014)
-- nvarchar(15) doesn't give complete valueit should be atleast nvachar(35)
you are right subhanshu-khurana
I have already send request for this.
Thanks for the comment.
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
August 13, 2014 at 12:25 am
Use below example :
DECLARE @i TABLE( mychar VARCHAR(50)
,deriv as SUBSTRING(mychar,1,3) --Use this
,newderiv as left(mychar,3)); --Or use this
INSERT @i VALUES ('Steve'), ('Stephan'), ('Stephanie')
...
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
August 11, 2014 at 3:32 am
Good Script..
It somewhat works like select the table and press alt+f1 .
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
August 5, 2014 at 11:44 pm
Your welcome dear!
Still it is difficult to understand and change the script.
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
August 5, 2014 at 11:22 pm
Good script 🙂
Either use
USE msdb
GO
in starting or...
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
August 5, 2014 at 11:15 pm
Interesting Script. 🙂
But it is not a good practice,
Although you have described every thing about the script, You should create script dynamically because all organizations have different timings,
Scholars...
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
August 5, 2014 at 10:49 pm
This script will fail while databases are in use.
User have to manually kill all processes related to those databases, which have to restore.
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
August 5, 2014 at 10:40 pm
Then use following link -
Truncate all tables reference foreign keys[/url]
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
August 5, 2014 at 10:34 pm
Hi This Script will not give any output but will rebuild or reorganize indexes.
This Script is only for production environment and it will create a job, You have to run...
Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature
April 15, 2014 at 5:43 am
Viewing 12 posts - 61 through 73 (of 73 total)