Viewing 15 posts - 496 through 510 (of 548 total)
We just had this issue yesterday where the Query Plan is not what it should be using, and a sp_recompile took the query from 10 secs to 1~2 secs
This is...
September 24, 2008 at 9:59 am
I've collected many index scripts over the time, don't know which one exactly fits, but this one does everything but the CREATION SCRIPT
--Create Procedure SQL_IndeXUsage as
Set NOCOUNT ON
------------------------------------------------
-- Auhtor: Saleem...
September 24, 2008 at 9:53 am
Rajan John (9/24/2008)
September 24, 2008 at 9:48 am
Wow, need to beautify your code
SELECT EmpId
,EmpFirstName
,EmpLastName
,EmpDeptNo
...
September 24, 2008 at 9:45 am
Thankfully I have RedGate tools
SQL Compare - compares schema and objects (view, stored procs, table, etc...)
SQL Data Compare - compares DATA inside tables
September 24, 2008 at 9:43 am
For your code
the derived table FIRSTRUN will return ALL results, since you didn't put a WHERE condition in there
easiest way: select the actual code inside the ( .... ), then...
September 24, 2008 at 9:41 am
+1 for sp_help_revlogin as well
Note it [the user/sys table] changes a bit in SQL Server 2005
Good thing that the script maintains the password, and the SID
so you shouldn't have Orphan...
September 24, 2008 at 9:39 am
Doug Andersen (9/23/2008)
Nope, because full-text searches complain when you attempt to search with a null.
Yes, the stupid NULL predicate
But maybe a clever getaround?
Hopefully the short circuit will pick up the...
September 24, 2008 at 9:35 am
I assumed you answered/fixed your own question, yes? 🙂
SELECT * INTO
creates actual table, and you cannot have duplicate column names in a table
September 24, 2008 at 9:32 am
Congrats
DBA 1, the world 0 😛
September 24, 2008 at 9:29 am
How about FTP access, yes?
Typical web hosting will give you control panel, file manager, FTP
Not necessarily Remote Desktop or VPN
so
1. issue a backup in T-SQL, or create a job to...
September 24, 2008 at 9:26 am
I agree, upgrade the RAM either way
We have a SQL 2008 box on Windows 2003 R2 (all 64-bit) with only 1.5GB RAM
DB is about ~30GB in total, it's slow as...
September 24, 2008 at 9:21 am
select *
from table
where country in (@countryparameter)
and customertype in (@customertypeparameter)
and (@name IS NULL OR contains(name,@name))
would this work?
September 23, 2008 at 12:40 pm
Oops, I was just about to post the test code that couldn't reproduce the issue
DECLARE @test-2 TABLE
(
Violation NVARCHAR(MAX) NOT...
September 23, 2008 at 12:36 pm
SW_Lindsay (9/23/2008)
Thanks for this, but the error comes up in the install process so there is no config manager to change it.Steve
Interesting, is it a valid Computer User...
September 23, 2008 at 12:25 pm
Viewing 15 posts - 496 through 510 (of 548 total)