Viewing 15 posts - 41,596 through 41,610 (of 49,562 total)
nashreen.mosaheb (1/19/2009)
January 19, 2009 at 1:06 am
Jeff Moden (1/18/2009)
Other than a firedrill on this forum, when have any of you actually had to concatenate data in SQL Server in such a fashion in production?
Couple times, but...
January 19, 2009 at 12:06 am
Client process won't give you the machine. It gives you the processid on that machine. For the machine, use the hostname column.
January 18, 2009 at 11:59 pm
kiransuram19 (1/18/2009)
January 18, 2009 at 11:56 pm
Jack Corbett (1/18/2009)
I've got a series on Profiler/Trace in process, building from real basic to a little more advanced (server-side traces, etc...).
Ah. I was considering writing on server-side...
January 18, 2009 at 3:32 pm
Use something like this as the basis for the view.
SELECT *
FROM
(SELECT MAX(OrderNO) as MaxOrder, itemID, UOM FROM SomeTable GROUP BY ItemID, UOM) Qualifying
INNER JOIN SomeTable...
January 18, 2009 at 3:30 pm
pat (1/18/2009)
Names must be in two-part format.
As the error says. 3-part naming is also not allowed. Hence, only objects within the same database.
Edit: There's a long list of restrictions...
January 18, 2009 at 2:14 pm
Garadin (1/18/2009)
Is that ever the case though? =).
Maybe. There's more than one company I know where the access control doesn't allow two entrances one after the other. If you swipe...
January 18, 2009 at 1:26 pm
A normal query isn't schema bound.
A simple view is not schema bound.
Both of those will run fine when referencing another server.
The restriction is that you cannot reference a remote...
January 18, 2009 at 1:05 pm
Yeah, true.
Even so, the only extra checks (afaik) that are added once checkdb with data purity has run successfully are the ones that you turn on by adding the...
January 18, 2009 at 1:03 pm
As the error says, you're not allowed to access a remove server in an object that's created WITH SCHEMABINDING.
January 18, 2009 at 12:18 pm
MichaelJasson (1/18/2009)
Do we need to restart the sql service everytime we enable any trace or this is applicable to only some of the traces?
If you enable the traceflag using DBCC...
January 18, 2009 at 12:15 pm
That's actually not that hard, providing it's impossible to have two sequential in's or out's and the first entry is going in.
Pseudocode:
SELECT * FROM
(SELECT *, ROW_NUMBER OVER (PARTITION BY EmployeeID...
January 18, 2009 at 12:08 pm
Ok.....
Since the OrderNo (in event items) is a != in the query, it's absolutely senseless to have it as the leading column. It means that SQL has to do a...
January 18, 2009 at 11:36 am
Two excellent places to look for details on the storage engine - http://blogs.msdn.com/sqlserverstorageengine/default.aspx and http://www.sqlskills.com/blogs/paul/
January 18, 2009 at 11:18 am
Viewing 15 posts - 41,596 through 41,610 (of 49,562 total)