RE: text data type definition
I understand the length criteria for varchar, I do not understand how length relates to text data types. thanks
2003-05-01
1 reads
security
RE: "with sample xxx percent" is your friend ...
OK, so it is gauche to reply to your own post. But here goes: And all your good work by setting the right sampling for index statistics can be destroyed by a well meaning DBA who sets up a regular script to call sp_dbupdatestats without the critical @resample='YES' parameter!
2003-05-01
1 reads
RE: An automatic incremental number for sub-division
Hi mgutzait, The way I see it - you need to have a increment value that starts from 1 for each division value... When the table is created just give the default value for increment as 0(zero)... And then in the Insert trigger for the table try out the following : Declare @Cur Int -- […]
2003-05-01
RE: An automatic incremental number for sub-division
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-01
RE: SQL Query problem - Please Help
Sorry, also when you include TOP clause, you can remove count(*) from the select list of sub query. SELECT * FROM t_retail where t_Retail.Pcde6P IN (SELECT top 100 PERCENT t_Retail.Pcde6P FROM t_Retail WHERE LEN (LTRIM(t_Retail.Pcde6P)) = 6 GROUP BY t_Retail.Pcde6P HAVING Count(t_Retail.Pcde6P) > 2 ORDER BY Count(*) DESC )
2003-05-01
RE: 2 Server Communication
You are tring to access SQL Server with 'trust connection' from IIS server. Option1 : create SQL Server login with proper permissions to your database and modify your ASP connection string to use 'SQL Server authentication' to access SQL Server. connStr = "Provider=SQLOLEDB;Server=x.x.x.x;Database=" & _ dbname & ";UID=username;PWD=password" Option2 : Grant 'NT Authority\Anonymous Logon' to […]
2003-04-30
RE: Operating system error 112(There is not enough spa
Where are you trying to save it on the destination server? Is it a partitioned drive? How much space is in that partition? For example: The destination server could have a drive partitioned into C and D. All together they could have 10GB free space, but the C drive could only have 2 GB left […]
2003-04-30
RE: Newbie SQL question
Check out the Books OnLine for ISNULL. ISNULL(check_expression, replacement_expression) Select ISNULL(mycolumn, 'NewEntry') -SQLBill
2003-04-30
RE: Operating system error 112(There is not enough spa
If you open a command prompt from the source to the destination and do a dir, do you have enought space? Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-04-30
2 reads
RE: Getting Certified
This is where the technique used by Patrick and by my alphabet soup certification friend is invaluable. By scheduling the test, you've got incentive. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-04-30
1 reads
Blogs
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...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
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