- use decimal[(p[, s])] check BOL in stead of float.- check constaints can help to delimit values : from BOL : ALTER TABLE doc_exd ADD CONSTRAINT exd_check CHECK (column_a between -99 and +99) alter table dox_exd ADD CONSTRAINT exd_check_precision CHECK (case column_a - cast(column_a as integer) when 0 then 1 when 0.5 […]
2004-04-20
As too my "only go off past experience". That isn't exactly true. I usually test the people I interview by asking them questions. Some certifications that I have took were not jokes and you actually got something useful from them. MS though seems to be more of a push a button and hope your right.My […]
2004-02-27
2004-02-11
Hi,In the sysperfinfo table there is a value Transactions/sec in the column counter_type. So you would need to probably check the cntr_value corresponding to this row. you would need to check the cntr_value for object_name SQLServeratabases, counter_type Transactions/sec, instance_name <database name> and counter_type 272696320correct me if i am wrongCheers
2004-01-20
How (and where) can it be set at the os level that the pagefile is not recreated each time the server restart?ThanksCarl
2004-01-20
2 reads
Sort of a Moment 22 then? How would you know if the address is valid without trying to send it? Only the mailserver knows if it can send the mail or not. However, if you wonder about how to validate a string to be conformant to a valid address (ie that the 'format' is right), […]
2004-01-14
I think I figued out why the package was not opening. One of my packages is accessing a file that is local to server. I am performing a data transformation on an Excel file stored on the server, when I try to open it from a remote computer opening the package fails however openeing from […]
2004-01-13
I have a couple of guesses, but can you post what goes wrong when you schedule the package? Do you get an error message?My guesses:1. The account that SQL Server Agent runs as doesn't have permission to open the text file.2. The text file is on the c:\ drive of your workstation rather than on […]
2004-01-13
And you are still positive that you recieve no messages at all? I must ask you if the query completes at all? If it does then you should recieve something in return. Have you tried it with a permanent table instead? Or try to specify the column name in the insert. Have no linked server […]
2004-01-13
Did you login to the server using sql server agent account when you set your the email profile? Your SQL Server Agent account also has to have the right to open that email profile.mom
2004-01-13
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers