|
|
-
Nirav Gandhi Commented 7 Months ago through Tutorials
--Also u can run on following method.....
DECLARE @returncode int
declare @ssisstr varchar(8000), @packagename varchar(200), @servername varchar(100)
set @packagename = 'E:\bin\employee.dtsx'
set @servername = 'E:\"SQL_BIN (...
|
-
Nirav Gandhi Liked 7 Months ago through Blogs
What would you do if someone tells you to parse and compile a T-SQL query without executing it? While there is no mechanism to realize this requirement through the SSMS UI, one can use the SET option - NOEXEC. This post is a quick introduction to the NO...
|
-
Nirav Gandhi learned 7 Months ago through Blogs
What would you do if someone tells you to parse and compile a T-SQL query without executing it? While there is no mechanism to realize this requirement through the SSMS UI, one can use the SET option - NOEXEC. This post is a quick introduction to the NO...
|
-
Nirav Gandhi lifesaver 7 Months ago through Blogs
What would you do if someone tells you to parse and compile a T-SQL query without executing it? While there is no mechanism to realize this requirement through the SSMS UI, one can use the SET option - NOEXEC. This post is a quick introduction to the NO...
|
-
Nirav Gandhi Liked 7 Months ago through Tutorials
Moving on to more serious DBA business, the copy and script database wizard have proven useful in generating copies of a database for troubleshooting of other purposes. This tutorial explores how to use these wizards and tweak scripting and copy options...
|
-
Nirav Gandhi Liked 7 Months ago through Syndicated Blogs
Know everything about SQL Server technologies and latest happenings, not to mention the best practices and sharing best from our own experience....
|
-
Nirav Gandhi Liked 7 Months ago through Just Learned
Found another good reason to avoid using IN clause in your TSQL Queries. See the example below:
<pre style="font-family:arial;font-size:12px;border:1px dashed #CCCCCC;width:99%;height:auto;overflow:auto;background:#f0f0f0;;background-image:URL(http...
|
-
Nirav Gandhi incorrect 7 Months ago through Just Learned
Found another good reason to avoid using IN clause in your TSQL Queries. See the example below:
<pre style="font-family:arial;font-size:12px;border:1px dashed #CCCCCC;width:99%;height:auto;overflow:auto;background:#f0f0f0;;background-image:URL(http...
|
-
Nirav Gandhi Commented 7 Months ago through Blogs
Also you can update Constraint name:
sp_rename 'PK__Date_Level_Part__4440F2E2', 'PK__Date_Level_Part__4440F2E21'...
|
-
Nirav Gandhi Liked 7 Months ago through Syndicated Blogs
*I'm working as a senior database administrator for Total System Services Inc. I've more than a decade of IT experience in development, technical training, and database administration on Microsoft SQL Server platforms. I've authored numerous SQL Server ...
|