Viewing 15 posts - 901 through 915 (of 1,583 total)
The fastest (and most accurate) is to query sys.indexes - example:
SELECT
c .row_count AS [RowCount]
FROM
sys. objects a
JOIN
sys. indexes b
...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 19, 2012 at 10:37 am
I don't believe there's a way within SQL to prohibit the truncation of the strings when it's assigned to the variable. How is this proc called? If it's...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 19, 2012 at 10:26 am
You will need to create a linked server to reference the example code FROM OPENROWSET('NAMEHERE',
The name used in the example is: 'MSDASQL'
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 19, 2012 at 10:04 am
Like already noted, "it depends" however, you can pretty easily add/drop articles from replication (I am assuming you are referring to transactional replication) if the immediate sync option is set...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 18, 2012 at 8:39 pm
I personally prefer SQL Diagnostic Manager (praying I don't get attacked from mentioning an Idera tool on here ;-)) - In my testing I liked the way the data was...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 18, 2012 at 8:29 pm
I would tend to agree with Fluffy :hehe: catch up on maintenance things, learn something new, read up on one of those articles I've had bookmarks to for several months,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 18, 2012 at 8:25 pm
do I also need to add them to system level as a system user?
Do you mean on the SQL Server box itself? If so, no. If you are...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 18, 2012 at 8:18 pm
Thanks for the easy one! Should have been "can temp tables" be used in UDFs - that may have fooled a few :hehe:
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 18, 2012 at 2:37 pm
Interesting...
Please post your full code causing the errors, including DDL for all the tables needed, and the scripts needed to populate at least a few rows into each table. ...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 14, 2012 at 10:19 pm
It works fine for me both ways...I dont get the error, seems to me you have something configured differently within your SSMS?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 14, 2012 at 1:57 pm
This assumes you have successfully set up and are able to use a linked server: SELECT
a.col1,
b.col1
FROM
LinkedServerA.DatabaseA.dbo.TableA
INNER JOIN LinkedServerB.DatabaseB.dbo.TableB
...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 13, 2012 at 10:22 am
Michael T2 (12/13/2012)
AND coalesce(txSubtype,'') <> 'BACKORDER'
no records are returned. thats why i am using the coalesce. Most of the records i need have a null...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 13, 2012 at 10:17 am
Never tried FORFILES but this works well and is very simplistic EXEC MASTER.dbo.xp_cmdshell 'del \\YourUNCPath\*.*'
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 13, 2012 at 9:11 am
The reason nearly everyone on here will chine in on the use of NOLOCK (locking hints in particular) is primary because of the byproduct of using it altogether (dirty reads/potentially...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 12, 2012 at 4:01 pm
Simply post the DDL into your reply, and if you want to get all fancy place it between the [ code ="sql"] INSERT TSQL HERE [/ code]
Of course remove the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 12, 2012 at 3:51 pm
Viewing 15 posts - 901 through 915 (of 1,583 total)