Viewing 15 posts - 61 through 75 (of 102 total)
That works great - thank you for helping me out.
January 20, 2010 at 9:32 am
More details...
I have an application that handles customer's requests to add users to be able to run our various software applications. To save time, I am adding functionality that allows...
September 8, 2009 at 9:07 pm
I'll give that a try, So far looks good. Thanks for helping me out.
June 17, 2009 at 4:01 pm
That's my problem - from where I'm running my query, I don't know if it is a 2000 or 2005 version. The select @@version gives too much information to accurately...
June 17, 2009 at 2:25 pm
On a 2005 DB I get rows when I perform:
SELECT * FROM sys.database_principals
On a 2000 DB I get:
Invalid object name 'sys.database_principals'.
Under the scenario I am using, I cannot log in...
June 17, 2009 at 1:44 pm
"So check how is SQL Server memory/OS memory? How is the disk I/O system is there backlog in the disk system that it is taking I/O to get information to...
March 19, 2009 at 3:32 pm
DBCC SHOWCONTIG scanning 'mytable' table...
Table: 'mytable'(1800393483); index ID: 1, database ID: 14
TABLE level scan performed.
- Pages Scanned................................: 6573
- Extents Scanned..............................: 826
- Extent Switches..............................: 825
- Avg. Pages per Extent........................: 8.0
- Scan...
March 19, 2009 at 1:09 pm
We ran this last night
DBCC DBREINDEX(my_table,' ',90)
sp_recompile my_table
I am just running a select count(*). Before took 29 seconds. Ran a minute ago took 6 seconds.
Here is a main question. We...
March 18, 2009 at 8:21 am
7) There is an index using these 5 columns and these values are checked: clustered index, unique values, filegroup - primary, fill factor -90.
If I perform some re-index, how can...
March 18, 2009 at 7:59 am
This works great and I can use it as a template going forward. Thank you very much.
February 26, 2009 at 1:02 pm
My original result set returns 348 rows from #tmp. I am using the 'with' you suggested after my original select. I get:
(2 row(s) affected)
....
....
....
....
(348 row(s) affected)
(1 row(s) affected)
Msg 530, Level...
February 25, 2009 at 8:56 pm
The statement terminated. The maximum recursion 100 has been exhausted before statement completion
I have a pretty big table - 350 rows
February 25, 2009 at 8:38 pm
I got it to run with no errors. I will change it up and try it with all of the real data and I'll let you know. Thanks for your...
February 25, 2009 at 8:22 pm
Bevan -
Msg 336, Level 15, State 1, Line 11
Incorrect syntax near 'cte'. If this is intended to be a common table expression, you need to explicitly terminate the previous...
February 25, 2009 at 8:14 pm
Thank you so much for heling me out - I will give it a try.
March 26, 2008 at 10:10 pm
Viewing 15 posts - 61 through 75 (of 102 total)