network profile
| bio | website | woodassoc.us/blog/b2e |
|---|---|---|
| location | United States | |
| age | ||
| visits | member for | 10 months |
| seen | Sep 27 '12 at 1:16 | |
| stats | profile views | 5 |
Independent Contractor, need a solution to a problem that is not a "Best Practices" problem, send me a message and we can discuss the opportunity
Favorite Online Tools:
Profiles:
Credentials:
- IT Professional (1995 - Present)
- Desktop Support (1995 - Present)
- Client/Server Development (2006 - Present)
- Web Development (2001 - Present)
- Sys Admin (2008 - Present)
- DBA (2006 - Present)
- VBA (1994 - 1999, 2011 - Present)
|
Sep 12 |
comment |
Does Reporting Services lock tables? @Shark but to not consider the Default settings when designing a query would be adding more resources that are unnecessary to your transactions. Just making sure you understand that the Implicit (Default) settings can carry weight into how your server processes transactions and what locking mechanisms are/not set per transaction. So to think of it as Explicit or Implicit is very important when it comes to Snapshot isolation. Seeing the forest vs the Tree. |
|
Sep 12 |
awarded | Scholar |
|
Sep 12 |
accepted | VARCHAR NULL storage |
|
Sep 12 |
awarded | Commentator |
|
Sep 12 |
comment |
Does Reporting Services lock tables? @DiegoJancic nod....Snapshot isnt technically new, since Access has been using it (in various forms) since 2000/2003'ish. MS SQL's earliest implementation was really in 2005, even though 2000 has a ghost of an implementation (which was nasty). Database Snapshots were fully implemented in 2008 with a more efficient form of Leaf Locks in 2008r2. In my experience, if you wanted a lock you explicitly design the query with the syntax, otherwise leave the Locking mechanism open by default. |
|
Sep 12 |
comment |
Does Reporting Services lock tables? @CleanFill experience in supporting those environments. You notice a bigger hit when your Service CPU Utilization hits around 75-80% utilization. |
|
Sep 12 |
comment |
Does Reporting Services lock tables? @Shark Really then why are Batches only committed at the end, and not while it is happening? If everything wasnt a SnapShot Isolation then you wouldnt need to Commit them at all. Read Committed is a subset of SnapShot Isolation. By definition a Snapshot is a view of data at the time of the query. |
|
Sep 12 |
comment |
Does Reporting Services lock tables? @DiegoJancic RS, if you mean RecordSets, are not TSQL. Even though the Query results in a TSQL, they are two different view points pending on which end of the transaction your talking about. |
|
Sep 12 |
comment |
SQL server moved, now can't use as linked server let us continue this discussion in chat |
|
Sep 12 |
comment |
SQL server moved, now can't use as linked server Linked server is at the server level, not SSMS. SSMS will do various searches using means not available to the SQL Server. SSMS is a client application that will use LDAP, AD and other Connection authentication means. SQL Server only uses OLE DB connectivity for Linked Servers. check this thread out |
|
Sep 12 |
comment |
SQL server moved, now can't use as linked server Another problem you are going to have, is the outdated connection properties of 2000. If they updated to SQL-2012/13, you may have a problem with connectivity from 2000. As 2000 is more than 2 version behind, Microsoft is notorious for deprecating alot of functionality in a connection library within 2 version. |
|
Sep 12 |
comment |
SQL server moved, now can't use as linked server It can be, it can be associated with the AD-Group they are members of, the Credential Group, or the Account used to login to the Server. Pending on how they setup the account your using pends on which UserLogin tree they edit. |
|
Sep 12 |
comment |
SQL server moved, now can't use as linked server In 2005, you could manage the rights of a UserLogin/Credential to specific server(s)/Database/Schema. As such, if they moved the server, the address changed (IP[4/6], HostName, Instance) and did not make the appropriate change to the UserLogin/Credential then your going to dead space. Which is what you are doing now, being pointed to a dead-end street. |
|
Sep 12 |
answered | Does Reporting Services lock tables? |
|
Sep 12 |
answered | SQL server moved, now can't use as linked server |
|
Jul 15 |
comment |
VARCHAR NULL storage I knew it was new to 2008(r2) but couldnt remember the keyword for the new attribute for varchar data type. |
|
Jul 13 |
awarded | Student |
|
Jul 13 |
asked | VARCHAR NULL storage |
