Viewing 15 posts - 406 through 420 (of 708 total)
One trick is to hit the table twice: the first pass selects the 'buy' columns and aliases their names to simply Curr and Amt, and the second pass select the...
November 12, 2009 at 4:37 pm
SET NOEXEC ON
After that, you can execute you procedure. The procedure will compile (and perform the object and syntax checks you seek), but will not execute.
If you wish...
November 10, 2009 at 1:55 pm
johnsonchase7 (11/6/2009)
<snip> Especially since the dbcc index defrag option is no longer supported in the sql server 2008.</snip>
Note that it's just the dbcc index defrag syntax that has been removed....
November 8, 2009 at 12:30 pm
Changing MAXDOP only makes the CXPACKET waits go away, but doesn't cure the problem. You'll get some cycles back from not having to assemble the streams, but the bottom...
October 29, 2009 at 4:11 pm
Note: see link at bottom of post.
There are two types of CALs: Machine and User.
A Device CAL licenses a single workstation/phone/etc. from which multiple users may interactively log in and...
October 12, 2009 at 3:35 pm
You may only install one default instance of SQL Server on a server.
For clustering to work, you must install an instance on every node (server) in the cluster...
October 12, 2009 at 3:05 pm
Fraggle-805517 (10/2/2009)
Eddie,By chance is this documented somewhere so I can read more on it, or is this just from your personal experience.
I just threw that together as an answer to...
October 5, 2009 at 2:27 pm
The key is the ability to recover to a specific point in time (mentioned above), and not just they time they took the 'SAN backup' (only relevant if you are...
October 2, 2009 at 3:13 pm
The link I provided explains type 8 and 11 as follows:
Type 8: password mismatch (you typed the wrong password)
Type 11: Valid login but server access failure
- This one is...
September 1, 2009 at 1:40 pm
If you're getting error 18456, then you're successfully connecting to the server, but the login is being denied.
To find details, view the SQL Server logs (I'm guessing SQL Server is...
September 1, 2009 at 12:31 pm
Clustered indexes and Primary Keys are two independant entities. It just turns out that most people build their primary keys also as clustered indexes, even when their queries would...
August 28, 2009 at 8:41 pm
I use the following script to pull a list of tables and space used. Add a HAVING clause to only return those tables with > 0 rows, and it...
August 21, 2009 at 11:26 am
SET NOEXEC ON
That will compile but not execute.
1. SET NOEXEC ON
2. Execute the code
3. SET NOEXEC OFF
...and react to any errors.
-Eddie
August 18, 2009 at 11:54 am
Add the CASE to the query before the PIVOT (the one that defines the data that is pivoted):
CASE WHEN @Var = 'TBT' THEN Amt1
...
August 17, 2009 at 3:28 pm
Viewing 15 posts - 406 through 420 (of 708 total)