Viewing 15 posts - 391 through 405 (of 1,583 total)
Speaking of "Assignments", was this all the information your were given? There's no clear information provided that really links each table together. Are you sure you have all...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 3, 2014 at 8:47 pm
Coriolan (3/3/2014)
Do you as a DBA handle data integrity and will tackle issues like these?
Yes, handle and govern the whole deal. If I'm responsible for maintaining the data, I'm...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 3, 2014 at 8:06 pm
Thanks, I will check those links out today (and there's no rush on the upgrade - even though it was budgeted and approved, it could actually be a year before...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 3, 2014 at 12:56 pm
Sounds ugly.
What you could do is create a separate table to store the duplicates "OldPatientRecords" or something similar. Use ROW_NUMBER/PARTITION BY to extract your duplicate records (i.e. Where Dups...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 3, 2014 at 12:46 pm
How about this?
SELECT [columns]
FROM Client c
INNER JOIN Services s ON
c.SomeColumn = s.SomeColumn
WHERE s.START > GETDATE()-80
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 3, 2014 at 10:20 am
So the 2nd point I mentioned worked for you (great!). If you post your execution plan, we can probably get that thing to run in seconds...I'm still thinking there's...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 3, 2014 at 10:05 am
As Mystery mentioned, do you have CDC (Change Data Capture) enabled? If so, it could be your culprit as it used replication behind the scenes).
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 3, 2014 at 9:43 am
They are already parameterized queries and the execution plans are going to be the same either way. To get around the cache bloat (and you may have already configured...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 3, 2014 at 9:40 am
Check for FK relationships, I believe you have to drop the FK constraints first, then try what you were doing.
Try running sp_help on the tables to see what is tied...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 3, 2014 at 12:10 am
Too many statements for your IF...block without proper BEGIN...END
(hyphens added to get around my VPN's proxy, so remove those)
Try this:
IF EXISTS ( SELECT * FROM...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 3, 2014 at 12:05 am
The best answer I can give you is, Latin - "Table" is derived from the classical Latin word "tabula."
Maybe it got its name because it's a structure that you can...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 2, 2014 at 11:56 pm
Actually this is the better article (it's the source for the one I previously posted, and is much more detailed)
http://www.mssqltips.com/sqlservertip/1174/scheduling-backups-for-sql-server-2005-express/
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 2, 2014 at 11:46 pm
You should be able to use sqlcmd without specifying credentials (I just provided a bad example above). Here's an article pretty much outlining exactly what you are trying to...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 2, 2014 at 11:44 pm
It depends on the kind of system you're talking about: OLAP/OLTP? What are the demands on the system on daily/weekly/monthly basis? How many databases/applications are supported by...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 2, 2014 at 9:47 pm
Curious to know how this panned out for you...did adding the extra log file help?
Wanted to mention another point...since you executed ALTER DATABASE MyDB
SET SINGLE_USER WITH ROLLBACK IMMEDIATE
I think you...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 2, 2014 at 7:52 pm
Viewing 15 posts - 391 through 405 (of 1,583 total)