RE: SQL SERVER 2000 LOGS
Mate, You can use Perfmon, Select:Databases: Percentage Log used,you can set this against individual or all.Also try sp_spaceused it might hlp.
2005-05-18
Memory Optimized Tables
RE: MCDBA
Carl,I obtained my MCDBA about two years ago. I definitely feel it was worth it as it helped me move from a unsatisfying job to a fantastic one.Like most DBAs, I took the two SQL Server exams first. They are tough but manageable. I then took 70-215 (Administering MS Windows 2000 Server) and 70-216 (Administering MS […]
2005-05-18
how to view the data/properties on a selected table
how do you view the data on a selected table? in sql 2000 you could do that by selecting the table and right click it then click return all rows.. what is the equivalent of that in sql beta 2005 3? i have a table named user and i want to see the information on […]
2005-05-18
2 reads
RE: How can I have two workflows pointing at on email task
The image doesn't show up, is it hosted on a publicly accesible server? Anyway, two workflows to one task will always work as an AND operation. You can bypass that by creating a workflow script in each of the preceeding tasks to alter the precedence constraint accordingly. However, I find that duplicating task objects usually […]
2004-10-28
The query processor ran out of STACK SPACE
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-10-18
bitwise identity for static lookup table???
I would like to create an identity on a static lookup table that can be used in bitwise operators. The static table will be used in a bitwise lookup to see if the particular record has an error against it. The main problem is that each record could have multiple errors. Example Valid0 = Item OK1 […]
2004-10-07
59 reads
RE: Reports are soo slooooowww
Just spotted something.There I was, happily pulling my hair out trying to get a report NOT to flow over 3 pages wide, happily clicking on the 'OPEN' button to view the PDF when suddenly one opened on it's own.The difference? I had Acrobat open in the background this time, I had just closed the document, […]
2004-03-08
RE: SQL statement help needed (2)
A question about finding duplicates turns into a thread about not having duplicated (rehashed) posts Anyway, I would be nice if when someone, like Ud4 in this case, finds what their looking for, to go ahead and paste the link to what they've found into the thread, since someone might "search" and find this thread, have […]
2004-03-03
Blogs
When It’s Still Viable
By Brian Kelley
If a technology is still viable, don’t overlook it. Don’t get caught up chasing...
T-SQL Tuesday #179: The Detective’s Toolkit
By Steve Jones
It’s time for the monthly T-SQL Tuesday blog party. This month a longtime friend,...
Moving T-SQL Tuesday to Jekyll
By Steve Jones
I got a message a few months back that Microsoft was deprecating the MySQL...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers