RE: Does a database shrink rebuild ALL indexes?
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!
2003-05-26
security
RE: Parallel ????
Is ur where clause sargable? I mean it uses indexed columns or uses non-indexed columns and is it using any function in where clause? U may gain some efficiency using indexes. U sure there are duplicate records in different databases u don't want more than once? If there are no duplicate records then use UNION […]
2003-05-26
RE: Thanks for taking the test!
quote: Brian, This page could not be found (23 May 1000 EST): http://qa.sqlservercentral.com/testcenter And I'm curious to see how I did against others. Sorry about that, I had a comma after TestCenter and it was screwing it all up. You can click on Test Center above to get to the area. Brian Knight bknight@sqlservercentral.com http://qa.sqlservercentral.com/columnists/bknight
2003-05-23
1 reads
RE: Parallel ????
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!
2003-05-23
RE: SQL DBA needed in Col. OH
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!
2003-05-22
RE: SQL server does not exist or access denied
Apologies for tagging on to this thread, but I'm getting a similar error message but its being raised in the application log of our web server. We have seperate web and database servers, and the problem appears to be intermitant. The error is raised by the OLE DB provider fro SQL Server. The 2 database […]
2003-05-22
1 reads
Test Your SQL Server Security Skills and Compete with your Friends!
Test to see how much you know about SQL Server security. If you're one of the members to pass the test (72% score or higher), you're entered into a contest to win a copy of AppDetective and one year's worth of support (over $1500 value)! You can only take the test question test once and it is not timed. After the test, you'll be given the answers and why one answer is more correct than another. Questions are randomly chosen from a pool.
2003-05-22
329 reads
RE: Job Permissions
I have users with less privilages who can see the jobs. This is really bugging me, please help. Thank you.
2003-05-21
2003-05-21
RE: How can I add Number at the end?
BTW, I was using 5409045121009 table structure. Also I didnt put in the leading zeros but that would be easy enough if you need it.
2003-05-21
1 reads
Blogs
Comparing an Old Running Total to Window Functions
By Steve Jones
Often I see running totals that are written in SQL using a variety of...
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
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