Viewing 15 posts - 3,226 through 3,240 (of 9,707 total)
NineIron (4/18/2014)
if the underlying table(s) is not indexed or poorly indexed (I have little control over this), will an indexed view work to speed up performance?
Yes and no. The problem...
April 18, 2014 at 6:25 am
Perry Whittle (4/18/2014)
Tony Sweet (4/17/2014)
It does not release RAM until you cycle the service or the OS tells it to give up the RAM.
or if you lower the max memory...
April 18, 2014 at 6:22 am
My w.a.g. is that probably a brackets issue. Domain\User usually needs to be surrounded by square brackets [Domain\User] or it causes issues in the drop statements. It appears at first...
April 18, 2014 at 6:19 am
I mostly agree with Grant, but I would put the Reporting database on the same instance as the non-mission critical (and rarely used) databases. That way any reporting doesn't interfere...
April 18, 2014 at 6:15 am
I always run into this problem when it's an object with a different schema than dbo. See if my article about Dropping Schema Owned Tables[/url] helps you out. It's about...
April 18, 2014 at 6:12 am
Are you running the job and package on the same server as the database? That's the only reason why I can think you might not see the SPID. You may...
April 18, 2014 at 6:06 am
This sounds like a contest or homework problem to me.
April 18, 2014 at 6:00 am
Are you looking for the difference between a SQL login and a Windows login? Or something else?
April 18, 2014 at 5:58 am
I force an XML source to generate an XSD when first adding a new file, then open up the XSD in TextPad or another editor to verify all the datatypes...
April 18, 2014 at 5:54 am
FYI: Indexed Views don't do well on high-volume insert tables.
I also seem to recall that trying to update the schema of underlying tables used in Indexed Views (WITH SCHEMABINDING)...
April 18, 2014 at 5:52 am
Depends on how big the backup is. You could use an Execute T-SQL Statement Task to send the email, but I think there's a size limitation on the attachment using...
April 18, 2014 at 5:44 am
vignesh.ms (4/18/2014)
also explain how does above query works ???
SQL Server Books Online is your best friend. If you don't have a local copy, download it from Microsoft.
Click Index and search...
April 18, 2014 at 5:37 am
What is the specific kind of locks that you are encountering?
How are your articles designed? Are they whole tables or queries? If queries, can you paste the offending ones here...
April 18, 2014 at 5:35 am
Googling the phrase "Export Novell eDirectory data to SQL Server 2008" gets me some links back to Microsoft, but none that specifically reference SQL Server. This link about ForeFront Identity...
April 18, 2014 at 5:32 am
Does it have to be Replication or can you just use SSIS to grab the data and move it into SQL that way?
April 18, 2014 at 5:25 am
Viewing 15 posts - 3,226 through 3,240 (of 9,707 total)